Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.

[leaf_yxj <leaf_yxj@xxxxxxx>]

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]" <[hidden email]> 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: Re:Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.
Sent from the PostgreSQL - general mailing list archive at Nabble.com.