make-user-that-can-do-everything.sql at 4449fca0cf433211b983fc6d5b2db1a0cb34e3a2 · huncholane/supabase-notes

supabase-notes/make-user-that-can-do-everything.sql

8 lines477 BSQL

1	GRANT ALL PRIVILEGES ON DATABASE development TO huncho;
2
3	GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO huncho;
4	GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO huncho;
5	GRANT ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public TO huncho;
6	ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO huncho;
7	ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON SEQUENCES TO huncho;
8	ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON FUNCTIONS TO huncho;