| 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: | Whole Thread | Raw Message | 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 |