1、启动sql*puls。
2、用system用户登录。
3、创建新用户:
create user <username> IDENTIFIED BY <password>
4、为新用户分配权限:
GRANT CREATE USER,DROP USER,ALTER USER,CREATE ANY VIEW,DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,DBA,CONNECT,RESOURCE,CREATE SESSION TO <username>