关于 oracle 权限的有关问题 要查的几张表
关于 oracle 权限的问题 要查的几张表
select * from dba_objects where object_name = 'GCAL_PKG_INBOUND';
select * from role_sys_privs where role = 'R2_DMM_UPDATE_ROLE';
select * from role_tab_privs where role = 'R2_DMM_UPDATE_ROLE' and table_name = 'GCAL_PKG_INBOUND';
select * from user_role_privs where username = 'PROD_OPGCEP2';
select * from role_tab_privs where role = 'R2_DMM_UPDATE_ROLE' and table_name = 'UTL_PKG_ERROR';
select * from dba_objects where object_name = 'GCAL_PKG_INBOUND';
select * from role_sys_privs where role = 'R2_DMM_UPDATE_ROLE';
select * from role_tab_privs where role = 'R2_DMM_UPDATE_ROLE' and table_name = 'GCAL_PKG_INBOUND';
select * from user_role_privs where username = 'PROD_OPGCEP2';
select * from role_tab_privs where role = 'R2_DMM_UPDATE_ROLE' and table_name = 'UTL_PKG_ERROR';