Oracle's basic operations

1. Create user (requires DBA authority to log in)

Create user username identified by password;

After you create a user, you authorize it, and if you do not authorize it, you will not be able to log in to the database or do anything:

Grant Connection,resource to user;

Among them: Connection and resource are two roles built into Oracle, and the basic situation of two roles is as follows:

Connect role:--is the typical right to grant the end user, the most basic

Alter session--Modify sessions

Create CLUSTER--Build a cluster

Create DATABASE link

Create SEQUENCE-Create sequence

Create session--Set up sessions

Create synonym--create synonyms

Create view--build views

RESOURCE role:--is granted to developers

Create CLUSTER--Build a cluster

Create PROCEDURE--build process

Create SEQUENCE-Create sequence

CREATE table--Build tables

Create TRIGGER--Create a trigger

Create type--build types

2. You can see what permissions the user has (this action must be logged on with DBA authority)

Select Grantee,privilege from Dba_sys_privs

where grantee= ' RESOURCE ' order by privilege;

3. Revoke Permissions

Revoke permission name from user name

4. Change your password

Alter user username identified by new password;

5. Unlock and lock your account

--Lock Account

Alter user username account lock;

--Cancel Account

Alter user username account unlock;

Oracle's basic operations