iamtheyammer

CRUD user creation postgres

Dec 19th, 2019
8,814
0
Never
2
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE USER username PASSWORD 'pwd';
  2.  
  3. GRANT SELECT, INSERT, UPDATE, DELETE, TRIGGER ON ALL TABLES IN SCHEMA public TO username;
  4. GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO username;
Advertisement