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

From: Chris Travers <chris(dot)travers(at)gmail(dot)com>
To: leaf_yxj <leaf_yxj(at)163(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.
Date: 2012-03-30 02:53:35
Message-ID: CAKt_ZfvaYE8ArsKvq0WbWfOdj0ot83GiJ_bUbQKQbTp2CVCgTA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Mar 29, 2012 at 7:49 PM, leaf_yxj <leaf_yxj(at)163(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message leaf_yxj 2012-03-30 03:19:25 Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.
Previous Message leaf_yxj 2012-03-30 02:49:31 double check the role has what's kind of the privilege? And the same for the objects. Thanks.