Assignment 3 ‐‐‐ User and privileges - eshan3101/DataBase-Architech GitHub Wiki

1. Create a user named as SHAUSR.

2.How to check number of users and their account status at DB level?

3. How to lock user account?

4. How to unlock user account?

5. How to identify the default tablespace allocated to a particular user?

6. How to drop a user normally and with CASCADE option?

7.How to check system privileges assigned to a user?

8.How to check object privileges assigned to a user?

9.How to check what roles are assigned to a user?

10.Create a script to kill all sessions of a specific user.

11.Grant system privileges (CREATE SESSION, CREATE TABLESPACE) to user SHAUSR

12.Grant system privileges (CREATE SESSION, CREATE TABLESPACE) to user SHAUSR1 with ADMIN OPTION.

13.How to check which user has ADMIN privileges?

14. Grant object privileges (SELECT, INSERT) to user SHAUSR to access HR.EMPLOYEES table

15. Grant object privileges (SELECT, UPDATE) to user SHAUSR1 with GRANT OPTION on HR.EMPLOYEES table.

16. Create a read user "SHA_READ" and grant SELECT privileges to access all HR schema database objects.

17. Revoke system privileges (CREATE SESSION, CREATE TABLESPACE) from user SHAUSR.

18. Revoke object privileges (SELECT, INSERT) from user SHAUSR on HR.EMPLOYEES table.