单表授权
grant select , insert, update, delete on 表名 to 被授权用户名;
grant select , insert, update, delete, references , alter, index on T_FIX_BIND_ROUTE to SPOS_USER3;
所有表授权
select 'grant select, insert, update, delete on ' ||t.tname||' to 被授权用户名;'
from tab t
where t.tabtype = 'TABLE';
单序列授权
grant select on 序列名 to 被授权用户名;
grant select on nac_user.seq_l_tradelist_atuoid to spos_user3;
授权某用户下所有序列
select 'grant select on ' ||t.sequence_name||' to 被授权用户名;'
from sys.dba_sequences t
where sequence_owner = '授权用户名(大写)' ;
存储过程授权
grant execute on nac_posp to spos_user3;
赋给用户调试权限
grant debug session to 用户名
DBA收回权限
select 'REVOKE ALL ON WEB_USER.' || T.object_name || ' FROM NAC_USER;'
from dba_objects t
where t.owner = 'WEB_USER'
AND T.object_type IN ('TABLE' , 'SEQUENCE' , 'VIEW' , 'PROCEDURE') --对象类型