Oracle创建用户并授权

SQL> conn scott/tiger as sysdba;
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as SYS
 
SQL> create user lch identified by "111111";
 
User created
  
SQL> grant create session to lch;
 
Grant succeeded
  
SQL> grant connect,resource to lch;
 
Grant succeeded
 
SQL> conn lch/111111;
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as lch
 
SQL>