[Oracle] Create user

(1) CREATE TABLE space

Create Tablespace space Name

DataFile ' e:\ filename. dat '

Size 1M

Autoextend on

(2) Create a user

--No, No.

--create user username identified by password;

--grant connect,resource to user name;

--grant create any view to user name;

--Delete the user if the user exists

--drop user username CASCADE;

--Create User

Create user username

Identified by "User name"

Default Tablespace user Name

Temporary tablespace TEMP

Profile DEFAULT;

--Grant/revoke role privileges

Grant connect to User name;

Grant DBA to User name;

Grant Exp_full_database to user name;

Grant Imp_full_database to user name;

Grant resource to user name;

--Grant/revoke System privileges

Grant alter any table to user name;

Grant analyze any to user name;

Grant create any index to user name;

Grant create any sequence to user name;

Grant create any table to user name;

Grant Select any table to user name;

Grant unlimited tablespace to user name;

To import another user from one user, you need to grant DBA authority:

GRANT DBA to User name

[Oracle] Create user