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