Assignment 3

USER Administration:

Create a user named as SHAUSR

Creating the user Verifying

How to check number of user and their account status at DB level?

How to lock user account?

Verifying

How to unlock User account?

How to identify the default tablespace allocated to particular user?

How to drop a user normally and with cascade option?

Normally Cascade Verifying

HOW to check system privilege assinged to a user?

How to check Object privilege assinged to a user?

How to check what roles is assinged to a user?

Create a script to Kill all session of a specific user?

PRIVILEGES:

Grant system privs (Create session, create tablespace) to user SHAUSR.

Grant system privs (Create session, create tablespace) to user SHAUSR1 admin option.

How to check which user has admin privs?

Grant object privs (Select, Insert) to user SHAUSR to access and insert HR.Employees tables.

Grant object privs (Select, Update) to user SHAUSRI to access and append HR.Employees tables with Grant option.

Create a read user "SHA_READ" and grant Select privs to access all HR Schemas database objects. (With Script)

Revoke system privs (Create session, create tablespace) from user SHAUSR.

Revoke object privs (Select, Insert) from user SHAUSR to restrict access HR.Employees tables.