Hi Chris, My bosses ask me to list all the users and all the privilege which the superuser granted to the users. Then they can double check that I did right thing or not? Thanks. Grace At 2012-03-30 10:54:50,"Chris Travers-5 [via PostgreSQL]" <ml-node+s1045698n5605567...@n5.nabble.com> wrote: On Thu, Mar 29, 2012 at 7:49 PM, leaf_yxj <[hidden email]> wrote: > Hi All friends. Thanks for you guys reply my questions. You helps me a lot. > THank you billions. Another help. THanks. > > After I create table and roles. I want to double check I grant the proper > privileges to the users. I can > use \dp and \z command to check the objects privilege. I can user pg_authid > to check the system privilege grantee to the users. Am I right??????? the > below is what I get from my test database.
Cna you be specific about what you are trying to check. Are you trying to check whether a user has access to a given role? If so check out pg_has_role(). Best Wishes, Chris Travers -- Sent via pgsql-general mailing list ([hidden email]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general If you reply to this email, your message will be added to the discussion below: http://postgresql.1045698.n5.nabble.com/double-check-the-role-has-what-s-kind-of-the-privilege-And-the-same-for-the-objects-Thanks-tp5605564p5605567.html To unsubscribe from double check the role has what's kind of the privilege? And the same for the objects. Thanks., click here. NAML Hi -- View this message in context: http://postgresql.1045698.n5.nabble.com/double-check-the-role-has-what-s-kind-of-the-privilege-And-the-same-for-the-objects-Thanks-tp5605564p5605597.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
