pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedUsers grants with setting options
3+ messages / 2 participants
[nested] [flat]
* Users grants with setting options
@ 2021-03-08 23:30 Nagaraj Raj <nagaraj.sf@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: Nagaraj Raj @ 2021-03-08 23:30 UTC (permalink / raw)
To: Pgsql Performance <pgsql-performance@lists.postgresql.org>
Hi,
I have a quick question, does role custom parameters settings will be granted to users well?
Does user c_role will have the same settings m_role.CREATE ROLE m_role ;CREATE ROLE c_role ;ALTER ROLE m_role SET configuration_parameter TO 'VALUE';GRANT m_role TO c_role;
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Users grants with setting options
@ 2021-03-08 23:46 David G. Johnston <david.g.johnston@gmail.com>
parent: Nagaraj Raj <nagaraj.sf@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: David G. Johnston @ 2021-03-08 23:46 UTC (permalink / raw)
To: Nagaraj Raj <nagaraj.sf@yahoo.com>; +Cc: Pgsql Performance <pgsql-performance@lists.postgresql.org>
On Mon, Mar 8, 2021 at 4:30 PM Nagaraj Raj <nagaraj.sf@yahoo.com> wrote:
> I have a quick question, does role custom parameters settings will be
> granted to users well?
>
Parameters are not inherited - the role credentials that are logging in are
the ones that are used to check for defaults. This "no" is not explicitly
documented that I can find; though easy enough to test.
David J.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Users grants with setting options
@ 2021-03-08 23:48 Nagaraj Raj <nagaraj.sf@yahoo.com>
parent: David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Nagaraj Raj @ 2021-03-08 23:48 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: Pgsql Performance <pgsql-performance@lists.postgresql.org>
Thank you for confirmation.
On Monday, March 8, 2021, 03:46:28 PM PST, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Mon, Mar 8, 2021 at 4:30 PM Nagaraj Raj <nagaraj.sf@yahoo.com> wrote:
I have a quick question, does role custom parameters settings will be granted to users well?
Parameters are not inherited - the role credentials that are logging in are the ones that are used to check for defaults. This "no" is not explicitly documented that I can find; though easy enough to test.
David J.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2021-03-08 23:48 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-03-08 23:30 Users grants with setting options Nagaraj Raj <nagaraj.sf@yahoo.com>
2021-03-08 23:46 ` David G. Johnston <david.g.johnston@gmail.com>
2021-03-08 23:48 ` Nagaraj Raj <nagaraj.sf@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox