Advertisement
UnknownKings

Untitled

Apr 21st, 2019
882
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.63 KB | None | 0 0
  1. --start
  2. create role clerk;
  3. grant select on appointment to clerk;
  4. grant select on product to clerk;
  5. grant select on doctor to clerk;
  6. grant select on patient to clerk;
  7. grant select on contacts to clerk;
  8. grant select on frames to clerk;
  9. grant select on medical_insurance to clerk;
  10. grant select on orders to clerk;
  11. grant select on order_line to clerk;
  12. grant select on prescription to clerk;
  13. grant select on vision_plan to clerk;
  14.  
  15.  
  16. create role manager;
  17. grant select, update, insert, delete on appointment to manager;
  18. grant select, update, insert, delete on product to manager;
  19. grant select, update, insert, delete on doctor to manager;
  20. grant select, update, insert, delete on patient to manager;
  21. grant select, update, insert, delete on contacts to manager;
  22. grant select, update, insert, delete on frames to manager;
  23. grant select, update, insert, delete on medical_insurance to manager;
  24. grant select, update, insert, delete on orders to manager;
  25. grant select, update, insert, delete on order_line to manager;
  26. grant select, update, insert, delete on prescription to manager;
  27. grant select, update, insert, delete on vision_plan to manager;
  28.  
  29. create role developer;
  30. grant all privileges to developer;
  31.  
  32. CREATE USER Clerk IDENTIFIED BY ClerkPass;
  33. GRANT create session, clerk to Clerk;
  34.  
  35. CREATE USER Manager IDENTIFIED BY ManagerPass;
  36. GRANT create session, manager to Manager;
  37.  
  38. CREATE USER Developer IDENTIFIED BY DeveloperPass;
  39. GRANT create session, developer to Developer;
  40.  
  41. --end
  42.  
  43.  
  44. Users:
  45. Clerk Username: Clerk
  46. Password: ClerkPass
  47.  
  48. Manager Username: Manager
  49. Password: ManagerPass
  50.  
  51. Developer Username: Developer
  52. Password: DeveloperPass
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement