SELECT r.rolname as username,r1.rolname as "role"
FROM pg_catalog.pg_roles r LEFT JOIN pg_catalog.pg_auth_members m
ON (m.member = r.oid)
LEFT JOIN pg_roles r1 ON (m.roleid=r1.oid)
WHERE r.rolcanlogin
ORDER BY 1;
-
https://dba.stackexchange.com/questions/136858/postgresql-display-role-memberschmod +t /tmp
or
chmod 1777 /tmp
-
http://www.linuxnix.com/2012/01/sticky-bit-set-linux.htmlUne commande qu'elle est bien :
namei /path/to/the/deepest/file
Affiche toutes les permissions + les owners de toute l'arborescence jusqu'au fichier.
via nicolasc
-
http://linux.about.com/library/cmd/blcmdl1_namei.htm