Greetings, * Laurenz Albe (laurenz.albe@xxxxxxxxxxx) wrote: > Ronen Nofar wrote: > > I have a weird case when running a query on the pg_settings view. > > I have two users, first one is the default user - postgres which is a superuser > > and another one is a role which i had created, i called it test_role and it's not a superuser. > > When I run a select on pg_settings with these two users I recieve different results. > > That is intentional, because some settings should only be > visible for superusers, for example everything that has to > do with the operating system (location of configuration file > or socket directories). This isn't quite correct any longer- with PG10, we have a default role called 'pg_read_all_settings' which can be GRANT'd to other roles to allow viewing of all settings, even those previously restricted to superuser-only. Thanks! Stephen
Attachment:
signature.asc
Description: Digital signature
