首先创建一个用户语句如下:
create user testuser identified by 123456;
然后给这个用户赋予权限语句如下:
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 testuser;
首先创建一个用户语句如下:
create user testuser identified by 123456;
然后给这个用户赋予权限语句如下:
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 testuser;
转载于:https://my.oschina.net/lupeng/blog/134871