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

[Holger Jakobs <holger@xxxxxxxxxx>]

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: OpenPGP_signature
Description: OpenPGP digital signature