Oracle user creation and management of permissions, roles, and objects

Createuser: createuserlvidentifiedbym215957055; where lv is the user name and m215957055 is the user name. However, you cannot connect to the database after the database is created, so you do not have the permissions assigned to it. Let's take a look at the following: 1. Permission classification: system permissions: user defined by the System

Create user: create user lv identified by m215957055, where lv is the user name and m215957055 is the user name. However, you cannot connect to the database after the database is created, so you do not have the permissions assigned to it. Let's take a look at the following: 1. Permission classification: system permissions: user defined by the System

Create a user;

Create user

Example:

Create user lv identified by m215957055;

Lv is the user name, m215957055 is the user name. However, you cannot connect to the database after the database is created, and you do not have the permission to grant it,

Let's take a look at the following:

I. Permission classification:
System permission: The system specifies the user's permission to use the database. (System permissions are for users ).
Object permission: the access permission of a certain user to tables or views of other users. (For tables or views ).
Ii. system permission management:
1. system permission classification:
DBA: it has all the privileges and is the highest system permission. only DBA can create a database structure.
RESOURCE: users with Resource permissions can only create entities, but cannot create database structures.
CONNECT: users with the Connect permission can only log on to Oracle, create entities, and create database structures.
For normal users: grant connect and resource permissions.
For DBA management users: grant the connect, resource, and dba permissions.
3. Data Objects
It refers to tables, views, processes ...... And so on
4. Roles
Pre-defined role: System Configuration During Installation
Custom role: a self-written role that grants permissions.
Specify a command to grant permissions
Example: grant connect to create a user; connection permission.
Revoke permission specify command: revoke select on emp to user; this is to revoke the user's permission to query the emp table
Permission downward transfer
Example: grant select on emp to user with grant option;