oracle给新用户赋值

前提

ORACLE新用户赋值

1.切换用户

su oracle  
（设置系统变量后 source 配置）
sqlplus /nolog  
conn /as sysdba

2.创建用户

create user TEST01 identified by TEST01;

3.各种赋值

grant connect,resource to TEST01; --不赋值dba权限，需要再加

grant create session to TEST01;   --session
GRANT debug any procedure, debug connect session TO TEST01;  --debug调试

grant select on v_$session to TEST01; --各种查询权限
grant select on v_$sesstat to TEST01;
grant select on v_$statname to TEST01; 

grant create view to TEST01

(select  * from dba_sys_privs d where d.grantee='TEST01';)
grant insert any table to TEST01;
grant delete any table to TEST01;
grant alter any table to TEST01;
grant update any table to TEST01;
grant select any table to TEST01;
grant create any table to TEST01;
grant create any procedure to TEST01;