Oracle user creation and management of permissions, roles, objects, etc. to be aware of

Create user;

Create user

Example:

Create user lv identified by m215957055;

Where LV is the user name, m215957055 is the user name. But note that after the creation you are not connected to this database, that you have not assigned to his authority,

Let's take a look at the following:

First, the Classification of rights:
System permissions: The system specifies the user's permission to use the database. (System permissions are for users).
Entity permissions: A permission user's access to other users ' tables or views. (For a table or view).
Second, System Rights Management:
1, System Permissions classification:
DBA: Has full privileges, is the highest system privilege, and only the DBA can create the database structure.
RESOURCE: A user with RESOURCE permission can only create entities and cannot create a database structure.
Connect: A user with connect permission can only log on to Oracle, not create an entity, and cannot create a database structure.
For normal users: Grant Connect, resource permissions.
For DBA administration users: Grant Connect,resource, dba authority.
Third, the data object
For example, a table, a view, a process ... such as
Four, the role
Predefined roles: System configuration at installation
Custom roles: Write your own role, and make the authorization limit.
The specified command that gives permission
Example: Grant connect to a new user; connection permissions.
Reclaim permissions Specify the command: Revoke select on the EMP to user; This is to reclaim the user's query permissions on the EMP table
Permission down Pass
Example: Grant select on the EMP to user with GRANT option;

Oracle user creation and management of permissions, roles, objects, etc. to be aware of