On Fri, Feb 16, 2018 at 3:50 PM, chris wrote:
> I'm sorry I realized that I only need to know which users have permissions
> to the table which I can do through
>
> $ psql -t
>
> SELECT grantee
> FROM information_schema.role_table_grants
> WHERE table_name='table_name'
> GROUP BY grantee;
>
> tha
I'm sorry I realized that I only need to know which users have
permissions to the table which I can do through
$ psql -t
SELECT grantee
FROM information_schema.role_table_grants
WHERE table_name='table_name'
GROUP BY grantee;
thanks!
On 02/16/2018 01:13 PM, chris wrote:
Thanks for the qui
Thanks for the quick response.
That does not work for what I need because I only need the owner and
permissions of one table, I need the grant to look like the output that
pg_dump displays.
ex:
GRANT ALL ON TABLE testing_cdc TO bob;
--
-- PostgreSQL database dump complete
--
I need a way
On Fri, Feb 16, 2018 at 2:47 PM, chris wrote:
> 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
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
