Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --start
- create role clerk;
- grant select on appointment to clerk;
- grant select on product to clerk;
- grant select on doctor to clerk;
- grant select on patient to clerk;
- grant select on contacts to clerk;
- grant select on frames to clerk;
- grant select on medical_insurance to clerk;
- grant select on orders to clerk;
- grant select on order_line to clerk;
- grant select on prescription to clerk;
- grant select on vision_plan to clerk;
- create role manager;
- grant select, update, insert, delete on appointment to manager;
- grant select, update, insert, delete on product to manager;
- grant select, update, insert, delete on doctor to manager;
- grant select, update, insert, delete on patient to manager;
- grant select, update, insert, delete on contacts to manager;
- grant select, update, insert, delete on frames to manager;
- grant select, update, insert, delete on medical_insurance to manager;
- grant select, update, insert, delete on orders to manager;
- grant select, update, insert, delete on order_line to manager;
- grant select, update, insert, delete on prescription to manager;
- grant select, update, insert, delete on vision_plan to manager;
- create role developer;
- grant all privileges to developer;
- CREATE USER Clerk IDENTIFIED BY ClerkPass;
- GRANT create session, clerk to Clerk;
- CREATE USER Manager IDENTIFIED BY ManagerPass;
- GRANT create session, manager to Manager;
- CREATE USER Developer IDENTIFIED BY DeveloperPass;
- GRANT create session, developer to Developer;
- --end
- Users:
- Clerk Username: Clerk
- Password: ClerkPass
- Manager Username: Manager
- Password: ManagerPass
- Developer Username: Developer
- Password: DeveloperPass
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement