Re: multiple roles for a user ? - Mailing list pgsql-sql

From Guillaume Lelarge
Subject Re: multiple roles for a user ?
Date
Msg-id CAECtzeWqG9YpazA7vqV1RcJ4=gSw04wHSPaB-BD-e3bXpmgTRg@mail.gmail.com
Whole thread Raw
In response to multiple roles for a user ?  (DECHERF Étienne <etienne.decherf-ext@aphp.fr>)
Responses Re: multiple roles for a user ?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql
Le lun. 5 nov. 2018 à 12:15, DECHERF Étienne <etienne.decherf-ext@aphp.fr> a écrit :
Hello,
I have a simple question to ask :
Is it possible to give multiple roles to the same user?

for example :
1. a general role "RoleA" for most users, for "grants and revokes" on certain tables and certain columns. 2. plus a role "Role_user" particular for each of them for its additional personal access
 with "grants" and "revokes" on other tables and columns
.


Yes, though you can only grant privileges this way. Not revoke some.


--
Guillaume.

pgsql-sql by date:

Previous
From: Stanton Schmidt
Date:
Subject: Re: multiple roles for a user ?
Next
From: "David G. Johnston"
Date:
Subject: Re: multiple roles for a user ?