pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRole Permission issue
2+ messages / 2 participants
[nested] [flat]
* Role Permission issue
@ 2023-02-10 08:14 Manmeet Singh <manmeetsdba@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Manmeet Singh @ 2023-02-10 08:14 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi Team,
We have created one role and assign the permission to that role for
example: Select on all tables.
Now i want to find out, what permissions we do have in this role..
Kindly help to provide the info on it.
Thanks
Manmeet Singh
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Role Permission issue
@ 2023-02-10 11:04 Erik Wienhold <ewie@ewie.name>
parent: Manmeet Singh <manmeetsdba@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Erik Wienhold @ 2023-02-10 11:04 UTC (permalink / raw)
To: Manmeet Singh <manmeetsdba@gmail.com>; pgsql-admin@lists.postgresql.org
> On 10/02/2023 09:14 CET Manmeet Singh <manmeetsdba@gmail.com> wrote:
>
> We have created one role and assign the permission to that role for example:
> Select on all tables.
>
> Now i want to find out, what permissions we do have in this role..
The ACL is spread over multiple tables, depending on the object type:
https://www.postgresql.org/docs/15/ddl-priv.html#PRIVILEGES-SUMMARY-TABLE
You can search for specific roles using aclexplode and filtering on grantee:
select relnamespace::regnamespace, relname, acl.*
from pg_class, aclexplode(relacl) acl
where acl.grantee = 'alice'::regrole
But you have to query each object type (pg_class, pg_proc, etc.) separately.
--
Erik
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-02-10 11:04 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-02-10 08:14 Role Permission issue Manmeet Singh <manmeetsdba@gmail.com>
2023-02-10 11:04 ` Erik Wienhold <ewie@ewie.name>
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