Oracle users, roles, and permissions

1. Oracle User

There are two types of Oracle users, one is System user SYS system, the other is ordinary user;
The view Dba_users stores all user information;
To create a user:
Create user username identified by password default Tablespace table space
Grant Session Permission: Grant create session to TEST;
Lock and Open accounts: Alter user TEST account Lock/unlock;
Modify password: Alter user TEST identified by 123;
Delete users: Drop user TEST cascade; Delete the user, and delete the objects under the user, such as tables, views, triggers, etc.

2. Oracle Permissions

Oracle permissions are divided into system permissions and object permissions;
System permissions are built-in to Oracle, independent of object-specific permissions, such as the creation of table permissions, connection database permissions;
Object permission is the operation permission for specific objects, such as tables, views, triggers, etc.
System Permissions View: System_privilege_map
Rights Assignment View: Dba_sys_privs
Reclaim system permissions revoke permissions from user
Object Permission Assignment
User table Permissions View: Dba_tab_privs
Grants grant permission on object to user with GRANT option;
Reclaim permissions: Revoke object permissions on object from user;

3. Oracle Role

A role is a set of permissions that can be assigned directly to a user without the need for a single assigned permission;
Grammar:
Create role name;
Use view Dba_roles to find role information;

　　

Create user Test identified by root default tablespace users;

Grant DBA to Test;

Oracle users, roles, and permissions