Re: how to list privileges on the database object itself via SQL?

[richard coleman <rcoleman.ascentgl@xxxxxxxxx>]

Holger, 

Thanks, I managed to get the code to work across versions myself.  

Unfortunately that doesn't rectify the situation which is that the only place I've seen so far to get access to that information is in an array of values in the datacl column in the pg_catalog.pg_database table by database.

rik.

On Wed, Apr 26, 2023 at 1:55 PM Holger Jakobs <holger@xxxxxxxxxx> wrote:

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