使用sqlplus命令登录oracle管理,假设需要创建test用户
drop user test cascade ;
create user test IDENTIFIED BY test;
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 test;
使用sqlplus命令登录oracle管理,假设需要创建test用户
drop user test cascade ;
create user test IDENTIFIED BY test;
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 test;