Advertisement
Guest User

Untitled

a guest
Oct 30th, 2014
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. SET ROLE apple;
  2. SELECT * FROM junior_classes;
  3. --ERROR: permission denied for relation junior_classes
  4. --EXPLANATION: superuser revoked all privileges from user apple
  5. SET ROLE cs165thru;
  6. GRANT ALL PRIVILEGES ON course TO apple;
  7. SET ROLE apple;
  8. SELECT * FROM junior_classes;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement