Users of Oracle

1.Oracle provides privileged users, such as SYSDBA or Sysoper, who are primarily used to perform maintenance operations on the database, such as starting a database, shutting down a database, establishing a database, and performing operations such as backup and recovery. The difference between SYSDBA and Sysoper is that SYSDBA not only has all the permissions of Sysoper, but also can establish a database and perform incomplete recovery.

Connect system/123456 as SYSDBA; login database as a privileged user

2. Create a user

Create user user_name identified by Pass_word default tablespace users temporary tablespace temp;

3. Modify the user

Alter user east identified by 123456; Change Password

Alter user East quota 20m on tbsp_1;//modify the disk quota on the tablespace to 20MB

Alter user SH account unlock; Unlock sh user

3. User authorization

Connect system/123456

Grant Connect,resource to east;

4. Object authorization

Grant Select,insert,delete,update on scott.emp to Xifang;

5. Revoke User Rights

Revoke resource from East; Revoke resource permissions for East

6. Revoke Object permissions

Connect system/123456

Revoke delete,update on scott.emp from Xifang;

7. Delete a user

Drop user User_name[cascade];

Users of Oracle