oracle创建用户并赋给权限

创建artery用户，密码也是artery，并赋予artery用户dba权限
首先，su - oracle
oracle
然后

SQL> conn / as sysdba
Connected to Oracle Database 10g Express Edition Release 10.2.0.1.0
Connected as SYS

SQL> 　　create user lihao identified by lihao ;

User created

SQL>


create user lihao identified by lihao ;


grant connect, resource,create table,create session to lihao;

grant dba, connect to lihao; //赋予dba权限


完成！