Postgres Pro
Downloads
Home   >   mailing lists

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

From Chris Travers
Subject Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.
Date
Msg-id CAKt_ZfvaYE8ArsKvq0WbWfOdj0ot83GiJ_bUbQKQbTp2CVCgTA@mail.gmail.com
Whole thread Raw
In response to double check the role has what's kind of the privilege? And the same for the objects. Thanks.  (leaf_yxj <leaf_yxj@163.com>)
Responses Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.
List pgsql-general
Tree view 
On Thu, Mar 29, 2012 at 7:49 PM, leaf_yxj <leaf_yxj@163.com> 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

pgsql-general by date:

Previous
From: leaf_yxj
Date:
Subject: double check the role has what's kind of the privilege? And the same for the objects. Thanks.
Next
From: leaf_yxj
Date:
Subject: Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.