User privileges

Started by Mihai Gheorghiuover 24 years ago2 messagesgeneral
Jump to latest
#1Mihai Gheorghiu
tanethq@earthlink.net

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?

Thank you all.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Mihai Gheorghiu (#1)
Re: User privileges

"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