Re: ALTER DEFAULT PRIVILEGES FOR ROLE

2019-01-30 Thread Adrian Klaver
ROLE IN SCHEMA public REVOKE ALL ON SEQUENCES  FROM ; ALTER DEFAULT PRIVILEGES FOR ROLE IN SCHEMA public GRANT SELECT,USAGE ON SEQUENCES  TO ; -- -- Name: DEFAULT PRIVILEGES FOR TABLES; Type: DEFAULT ACL; Schema: public; Owner: -- ALTER DEFAULT PRIVILEGES FOR ROLE IN SCHEMA public REVOKE

ALTER DEFAULT PRIVILEGES FOR ROLE

2019-01-30 Thread Hilbert, Karin
After a database was updated by the application, a schema dump showed the following default privilege statements: -- -- Name: DEFAULT PRIVILEGES FOR SEQUENCES; Type: DEFAULT ACL; Schema: public; Owner: gitlab_dbo -- ALTER DEFAULT PRIVILEGES FOR ROLE IN SCHEMA public REVOKE ALL ON SEQUENCES