Postgres Pro
Downloads
Home   >   mailing lists

Re: how to list privileges on the database object itself via SQL? - Mailing list pgsql-admin

From Holger Jakobs
Subject Re: how to list privileges on the database object itself via SQL?
Date
Msg-id fd81361e-fa84-1d75-d944-1c590de0e424@jakobs.com
Whole thread Raw
In response to how to list privileges on the database object itself via SQL?  (richard coleman <rcoleman.ascentgl@gmail.com>)
Responses Re: how to list privileges on the database object itself via SQL?  (Erik Wienhold <ewie@ewie.name>)
Re: how to list privileges on the database object itself via SQL?  (richard coleman <rcoleman.ascentgl@gmail.com>)
List pgsql-admin
Tree view
Am 26.04.23 um 19:53 schrieb richard coleman:
Erik, 

Thanks for that.  I'll have to look into the aclexplode() function some more.

When I try running your SQL on a pg11 database I get:

ERROR:  role "role" does not exist
LINE 3:         WHERE grantee = 'role'::regrole AND privilege_type I...
                                ^
SQL state: 42704
Character: 151

rik.

If you want to use the SQL statements used by psql on older versions of PostgreSQL, you should use the old version of psql.


-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachment

pgsql-admin by date:

Previous
From: richard coleman
Date:
Subject: Re: Am I being blacklisted?
Next
From: richard coleman
Date:
Subject: Re: how to list privileges on the database object itself via SQL?