Re: multiple roles for a user ?

Guillaume Lelarge <[email protected]> Mon, 5 Nov 2018 14:25:12 +0100

Newsgroups	gmane.comp.db.postgresql.sql
Message-ID	<CAECtzeWqG9YpazA7vqV1RcJ4=gSw04wHSPaB-BD-e3bXpmgTRg@mail.gmail.com>

Le lun. 5 nov. 2018 à 12:15, DECHERF Étienne <[email protected]>
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.