Re: multiple roles for a user ?

agora inbox for pgsql-sql@postgresql.org  
help / color / mirror / Atom feed

From: Stanton Schmidt <sschmidt@rgllogistics.com>
To: DECHERF Étienne <etienne.decherf-ext@aphp.fr>
Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Subject: Re: multiple roles for a user ?
Date: Mon, 5 Nov 2018 07:03:03 -0600 (CST)
Message-ID: <872659542.9918682.1541422983710.JavaMail.zimbra@rglholdings.com> (raw)
In-Reply-To: <35B45AE5854FD442A1775EB1337F9701C937BE@BBS-EXCMBX-P005.wprod.ds.aphp.fr>
References: <35B45AE5854FD442A1775EB1337F9701C937BE@BBS-EXCMBX-P005.wprod.ds.aphp.fr>

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.decherf-ext@aphp.fr> 
To: "pgsql-sql" <pgsql-sql@lists.postgresql.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

view thread (4+ messages)  latest in thread

Message-ID: <872659542.9918682.1541422983710.JavaMail.zimbra@rglholdings.com>
Permalink:  ../872659542.9918682.1541422983710.JavaMail.zimbra@rglholdings.com/
Also on:    postgresql.org/message-id/872659542.9918682.1541422983710.JavaMail.zimbra@rglholdings.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: sschmidt@rgllogistics.com, etienne.decherf-ext@aphp.fr, pgsql-sql@lists.postgresql.org
  Subject: Re: multiple roles for a user ?
  In-Reply-To: <872659542.9918682.1541422983710.JavaMail.zimbra@rglholdings.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox