gathering ownership and grant permissions - Mailing list pgsql-general

From chris
Subject gathering ownership and grant permissions
Date
Msg-id 2bc1e56d-74ea-3590-a253-970f0e564467@pgsqlrocket.com
Whole thread Raw
Responses Re: gathering ownership and grant permissions  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
HI,

I would like to know if there is a better way to grab the grant 
permissions  as well as the "owner to" of a table.

I can currently do this through a pg_dumb with greps for "^grant" and 
"^alter" but than I need to do a word search of those lines looking for 
the specific answers which gets much more involved.

I essentially need to know what grant command was ran and use that grant 
permission to set to a variable for a script.

Ex: GRANT ALL ON TABLE testing TO bob; then set only the "all" to a 
variable.

And then same for the ALTER .... OWNER TO bob.

This is on postgresl 9.6.

Thank you,

Chris



pgsql-general by date:

Previous
From: "Basques, Bob (CI-StPaul)"
Date:
Subject: Re: Database health check/auditing
Next
From: Melvin Davidson
Date:
Subject: Re: Database health check/auditing