Oracle 查看用户全部权限

Oracle 查看用户所有权限

 

 --查看用户所有权限
 select * from session_privs t
 --查看执行触发器权限
 select * from session_privs t WHERE  t.privilege LIKE '%TRIGGER%';
 --查看执行触发器权限
 select owner, object_name, object_type, status from dba_objects where object_name = '<TRIGGER_NAME>';