SQL> create user 用户名 identified by 密码
2 grant create user,drop user,alter user,create any view,drop any view,exp_full_database,imp_full
_database,dba,connet,resource,create session to 用户名
3 commit
4
我的实验结果:
SQL> create user wtxtools
2 identified by wtxtools;
User created.
SQL> grant create user,drop user,alter user,create any view,drop any view,exp_full_database,imp_full_database,dba,resource,create session to wtxtools;
Grant succeeded.
SQL> commit;
Commit complete.