Postgres Pro
Downloads
Home   >   mailing lists

Re: User privileges - Mailing list pgsql-general

From Tom Lane
Subject Re: User privileges
Date
Msg-id 24963.1003288627@sss.pgh.pa.us
Whole thread Raw
In response to User privileges  ("Mihai Gheorghiu" <tanethq@earthlink.net>)
List pgsql-general
Tree view 
"Mihai Gheorghiu" <tanethq@earthlink.net> writes:
> It is possible that a user is a member of more than one group.
> Do this user's privileges AND or OR the privileges of each of the two
> groups?

OR.  A user's privileges are always the union of what he has personally
and what he has via any group.  See aclcheck() in
src/backend/catalog/aclchk.c: it keeps looking for any way to grant
permission.

            regards, tom lane

pgsql-general by date:

Previous
From: Emmanuel SARACCO
Date:
Subject: Re: Queries and views
Next
From: Andrej Falout
Date:
Subject: Re: A tool for making console/text data enrty/display screens in C