Oralce Create User PL/SQL

Authority：
create session     
create table               
unlimited tablespace

connect
resource
dba

example:

#PL/SQL

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 
Connected as SYS

SQL> create user Louis identified by 123456;
SQL> grant dba to Louis;
SQL> conn Louis/123456
SQL> select * from user_sys_privs;

 

We are going to create the Oracle user permissions from the table started talking, and then interpretation on general action, make everyone to have a deep understanding of Oracle user permissions table.

sys： system administrator, has the highest authority
system：local administrators, higher authority
Scott：a regular user, the password by default for the tiger, the default is not unlocked

Create User