Re: multiple roles for a user ?

Yes it is.

stanton schmidt
Database Administrator
direct. [ callto:920.884.1281 | 920. ] 471.4495 cell 920.660.1828

RGL
GO AHEAD. ASK WHAT IF.
[ http://www.rgllogistics.com/ | www.RGLlogistics.co m ]

From: "DECHERF Étienne" <etienne(dot)decherf-ext(at)aphp(dot)fr>
To: "pgsql-sql" <pgsql-sql(at)lists(dot)postgresql(dot)org>
Sent: Monday, November 5, 2018 5:15:08 AM
Subject: multiple roles for a user ?

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 .

Thanks.
Regards.

Etienne DECHERF
SOPRA STERIA
for APHP Paris