Le lun. 5 nov. 2018 à 12:15, DECHERF Étienne <etienne(dot)decherf-ext(at)aphp(dot)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.