blob: 5599df49420255d250e5995ce58f1186963cfe35 [file]
ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA public GRANT SELECT ON TABLES TO app_user;
ALTER DEFAULT PRIVILEGES FOR ROLE a, b IN SCHEMA s1, s2 GRANT SELECT, INSERT ON TABLES TO app WITH GRANT OPTION;
ALTER DEFAULT PRIVILEGES IN SCHEMA s FOR ROLE a FOR ROLE b GRANT SELECT ON TABLES TO app;
ALTER DEFAULT PRIVILEGES FOR USER bob GRANT ALL PRIVILEGES ON SEQUENCES TO app;
ALTER DEFAULT PRIVILEGES GRANT EXECUTE ON FUNCTIONS TO app;
ALTER DEFAULT PRIVILEGES GRANT USAGE ON ROUTINES TO app;
ALTER DEFAULT PRIVILEGES GRANT USAGE, CREATE ON TYPES TO app;
ALTER DEFAULT PRIVILEGES GRANT SELECT ON SCHEMAS TO app;
ALTER DEFAULT PRIVILEGES GRANT SELECT, UPDATE ON LARGE OBJECTS TO app;
ALTER DEFAULT PRIVILEGES REVOKE SELECT ON TABLES FROM app;
ALTER DEFAULT PRIVILEGES REVOKE GRANT OPTION FOR ALL ON TABLES FROM app CASCADE