Create a new user and permission assignment table in Oracle

Create user

Create User Username identified by password;

 

System Permissions

Grant/Revoke create session to/from username;

Grant/Revoke create table to/from username;

Grant/Revoke unlimited tablespace to/from user name;

Grant dBA, connect, resource to tanbin

Import Database
IMP 'tanbin/tanbin' file = 'e:/company documentation/doshare. dmp 'fromuser = do1__lychee touser = tanbin rows = y indexes = y

Grant create session to public;

Query the system permissions of the current user

Select * From user_sys_privs;

 

Object permission

Grant/Revoke select on table name to/from user name;

Grant/Revoke all on table name to/from user name;

 

Query object permissions of the current user

Select * From user_tab_privs;

 

Object permissions can be controlled to columns

Grant Update (column name) on table name to user name;
IMP 'chenjian/chenjian 'file = 'e:/gzkhxt. dmp' fromuser = yxzckh touser = chenjian rows = y indexes = y

Grant create session to chenjian;

Grant create table to chenjian;

Grant unlimited tablespace to chenjian;

Grant dBA, connect, resource to chenjian