Oracle create user password modification authorization command

Create user [username] identified by [Password] Create a new user

Grant permission 1. Permission 2... to grant the user the permission to create a user

Ex: grant create session to [username] at this time, you can only connect to the database

Grant connect, resource to [username]. The permission can meet the requirements.

Alter user [username] identified by [Password] Change User Password

Alter user [username] password expired prompt to Change Password Upon next login

Alter user [username] account lock user

Alter user [username] account unlock lock user

Grant select, delete on Scott. EMP to [username] give the user two permissions for the EMP table under Scott

Revoke select, delete on Scott. Emo from [username] revoke permissions

 

// Create a user and specify the tablespace

Create User Username identified by password

Default tablespace user_data

Temporary tablespace user_temp;

// Grant permissions to users

Grant connect, resource to username;

// Log on to the user later. Any database objects created belong to the user_temp and user_data tablespaces,

This eliminates the need to specify a tablespace for each created object.

Withdrawal:

Revoke permission... from user name;

Delete USER commands

Drop user user_name cascade;

 

 

During procedure execution, the test in PL/SQL tool is used for execution. The debugging method is executed because there are input parameters, but an error is reported:
"NOTE: Debugging requires the debug connect session system privilege ".

The reason is that the user has insufficient permissions. Use the following command to grant permissions:
Grant debug any procedure, debug connect session to Username
In fact, you only need to authorize the debug connect session. It has been tested.