Re: [GENERAL] How to delete default privileges

2017-08-15 Thread Jeff Janes
On Tue, Aug 15, 2017 at 3:02 PM, Francisco Reyes wrote: > I have a DB where we changed ownership of all objects. > > We had: > > ALTER DEFAULT PRIVILEGES FOR ROLE old_dbowner GRANT SELECT ON tablesTO > dbgroup_ro_group; > ALTER DEFAULT PRIVILEGES FOR ROLE old_dbowner GRANT SELECT ON sequences

[GENERAL] How to delete default privileges

2017-08-15 Thread Francisco Reyes
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_dbown