Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gJeXj-0003R1-4J for pgsql-sql@arkaria.postgresql.org; Mon, 05 Nov 2018 13:03:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gJeXh-00085V-Id for pgsql-sql@arkaria.postgresql.org; Mon, 05 Nov 2018 13:03:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gJeXh-00081d-85 for pgsql-sql@lists.postgresql.org; Mon, 05 Nov 2018 13:03:45 +0000 Received: from mx0b-0021dc01.pphosted.com ([148.163.152.220] helo=mx0a-0021dc01.pphosted.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gJeXY-0001Qh-1n for pgsql-sql@lists.postgresql.org; Mon, 05 Nov 2018 13:03:43 +0000 Received: from pps.filterd (m0096563.ppops.net [127.0.0.1]) by mx0b-0021dc01.pphosted.com (8.16.0.27/8.16.0.27) with SMTP id wA5D24WI002937; Mon, 5 Nov 2018 07:03:32 -0600 Received: from mail.rglholdings.com (dns152.b.register.com [98.102.82.53] (may be forged)) by mx0b-0021dc01.pphosted.com with ESMTP id 2nh5tfrm8j-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Mon, 05 Nov 2018 07:03:32 -0600 Received: from mail.rglholdings.com (localhost [127.0.0.1]) by mail.rglholdings.com (Postfix) with ESMTPS id A724914B13; Mon, 5 Nov 2018 07:03:04 -0600 (CST) Received: from localhost (localhost [127.0.0.1]) by mail.rglholdings.com (Postfix) with ESMTP id 97BA314ACC; Mon, 5 Nov 2018 07:03:04 -0600 (CST) X-Virus-Scanned: amavisd-new at rglholdings.com Received: from mail.rglholdings.com ([127.0.0.1]) by localhost (mail.rglholdings.com [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id B2WJbso4URKn; Mon, 5 Nov 2018 07:03:04 -0600 (CST) Received: from mail.rglholdings.com (mail.ipa.rglholdings.com [10.1.20.35]) by mail.rglholdings.com (Postfix) with ESMTP id 78F5814A16; Mon, 5 Nov 2018 07:03:04 -0600 (CST) Date: Mon, 5 Nov 2018 07:03:03 -0600 (CST) From: Stanton Schmidt To: DECHERF =?utf-8?Q?=C3=89tienne?= Cc: pgsql-sql Message-ID: <872659542.9918682.1541422983710.JavaMail.zimbra@rglholdings.com> In-Reply-To: <35B45AE5854FD442A1775EB1337F9701C937BE@BBS-EXCMBX-P005.wprod.ds.aphp.fr> References: <35B45AE5854FD442A1775EB1337F9701C937BE@BBS-EXCMBX-P005.wprod.ds.aphp.fr> Subject: Re: multiple roles for a user ? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_ea28b0ea-e56d-42b1-a657-fdfd7371991a" X-Originating-IP: [10.1.20.35] X-Mailer: Zimbra 8.7.11_GA_3012 (ZimbraWebClient - GC70 (Win)/8.7.11_GA_3012) Thread-Topic: multiple roles for a user ? Thread-Index: AQHUdPiInfIFBSBllEOvthDTgcbui7AE0u+h X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:,, definitions=2018-11-05_08:,, signatures=0 X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 suspectscore=9 malwarescore=0 phishscore=0 bulkscore=0 spamscore=0 mlxscore=0 lowpriorityscore=0 mlxlogscore=562 adultscore=7 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.0.1-1807170000 definitions=main-1811050121 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --=_ea28b0ea-e56d-42b1-a657-fdfd7371991a Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Yes it is.=20 stanton schmidt=20 Database Administrator=20 direct. [ callto:920.884.1281 | 920. ] 471.4495 cell 920.660.1828=20 RGL=20 GO AHEAD. ASK WHAT IF.=20 [ http://www.rgllogistics.com/ | www.RGLlogistics.co m ]=20 From: "DECHERF =C3=89tienne" =20 To: "pgsql-sql" =20 Sent: Monday, November 5, 2018 5:15:08 AM=20 Subject: multiple roles for a user ?=20 Hello,=20 I have a simple question to ask :=20 Is it possible to give multiple roles to the same user? for example :=20 1. a general role "RoleA" for most users, for "grants and revokes" on certa= in tables and certain columns. 2. plus a role "Role_user" particular for each of them for its additional p= ersonal access=20 with "grants" and "revokes" on other tables and columns .=20 Thanks.=20 Regards.=20 Etienne DECHERF=20 SOPRA STERIA=20 for APHP Paris=20 --=_ea28b0ea-e56d-42b1-a657-fdfd7371991a Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Yes it is.
stanton = schmidt
Database Administrator
direct. 920.471.4495 &n= bsp;cell 920.660.1828
<= br>RGL
GO AHEAD. ASK = WHAT IF.
www.RGLlogistics.co m

From: "DECHERF =C3=89tienne" <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 use=
r?

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 p=
ersonal access
 with "grants" and "revokes" on other tables and col=
umns.

Thanks.
Regards.

Etienne DECHERF
SOPRA STE=
RIA
for APHP Paris

--=_ea28b0ea-e56d-42b1-a657-fdfd7371991a--