Postgres Pro
Downloads
Home   >   mailing lists

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

From DECHERF Étienne
Subject multiple roles for a user ?
Date
Msg-id 35B45AE5854FD442A1775EB1337F9701C937BE@BBS-EXCMBX-P005.wprod.ds.aphp.fr
Whole thread Raw
Responses Re: multiple roles for a user ?  (Stanton Schmidt <sschmidt@rgllogistics.com>)
Re: multiple roles for a user ?  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: "Mark Williams"
Date:
Subject: RE: Regular Expressions
Next
From: Stanton Schmidt
Date:
Subject: Re: multiple roles for a user ?