iamtheyammer

CRUD user creation postgres

Dec 19th, 2019
6,536
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
Comments
  • User was banned
  • User was banned
Add Comment
Please, Sign In to add comment