Re: multiple roles for a user ?

Stanton Schmidt <[email protected]> Mon, 5 Nov 2018 07:03:03 -0600 (CST)

Newsgroups	gmane.comp.db.postgresql.sql
Message-ID	<[email protected]>

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" <[email protected]> 
To: "pgsql-sql" <[email protected]> 
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