Advertisement
kastielspb

Postgres fix owner permissions

May 23rd, 2019
217
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.33 KB | None | 0 0
  1. GRANT usage ON schema public TO public;
  2. GRANT CREATE ON schema public TO public;
  3.  
  4. psql microzaim_db -c "GRANT ALL ON ALL TABLES IN SCHEMA public to microzaim_db;"
  5. psql microzaim_db -c "GRANT ALL ON ALL SEQUENCES IN SCHEMA public to microzaim_db;"
  6. psql microzaim_db -c "GRANT ALL ON ALL FUNCTIONS IN SCHEMA public to microzaim_db;"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement