huncholane/supabase-notesPublic

main

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

9 lines524 BSQL

RawDownloadHistory

1	CREATE ROLE huncho WITH password "**********";
2	GRANT ALL PRIVILEGES ON DATABASE development TO huncho;
3
4	GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO huncho;
5	GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO huncho;
6	GRANT ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public TO huncho;
7	ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO huncho;
8	ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON SEQUENCES TO huncho;
9	ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON FUNCTIONS TO huncho;