From: | Francisco Reyes <lists(at)natserv(dot)net> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | How to delete default privileges |
Date: | 2017-08-15 22:02:09 |
Message-ID: | 11bbc65c-1087-08c8-397c-69c78bbd1838@natserv.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a DB where we changed ownership of all objects.
We had:
ALTER DEFAULT PRIVILEGES FOR ROLE old_dbowner GRANT SELECT ON tables
TO dbgroup_ro_group;
ALTER DEFAULT PRIVILEGES FOR ROLE old_dbowner GRANT SELECT ON sequences
TO dbgroup_ro_group;
ALTER DEFAULT PRIVILEGES FOR ROLE old_dbowner GRANT SELECT, UPDATE,
DELETE, INSERT ON tables TO dbgroup_rw_group;
ALTER DEFAULT PRIVILEGES FOR ROLE old_dbowner GRANT SELECT,
USAGE ON sequences TO dbgroup_rw_group;
ALTER DEFAULT PRIVILEGES FOR ROLE old_dbowner GRANT
EXECUTE ON functions TO dbgroup_rw_group;
But now there is a new DB owner and I have run the above, but with
new_dbowner. How can I delete the old default grants? Can't find
examples and don't see it on the documentation either.
Any help would be greatly appreciated.
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2017-08-15 22:26:26 | Re: How to delete default privileges |
Previous Message | Daryl Stultz | 2017-08-15 21:34:04 | Re: Corrupt index |