先看这个对象在对象库里是否存在
select * from dba_objects where object_name like '%GCAL_PKG_INBOUND%' and owner like 'BUAT_META%';
然后在tab表里看赋给谁权限了
select * from dba_tab_privs where table_name like '%GCAL_PKG_INBOUND%' and owner like 'BUAT_META%';
最后看那个role有啥权限
select * from dba_role_privs where GRANTEE like 'OPGCEP1';
----------------看某个process id 是否拥有某种权限------------------
1.比如 BUAT 环境, 一个 opgcep1的process id
select * from dba_role_privs where GRANTEE like 'OPGCEP1';
查出 这个 opgcep1拥有哪些 权限角色
2.然后看这些权限角色是否拥有操作某些schema的权限
select * from dba_tab_privs where table_name like '%REMEDIATION4_Q%' and owner like 'BUAT_META%' AND GRANTEE = 'GCE1_DMM_UPDATE_ROLE';
select * from dba_objects where object_name like '%GCAL_PKG_INBOUND%' and owner like 'BUAT_META%';
然后在tab表里看赋给谁权限了
select * from dba_tab_privs where table_name like '%GCAL_PKG_INBOUND%' and owner like 'BUAT_META%';
最后看那个role有啥权限
select * from dba_role_privs where GRANTEE like 'OPGCEP1';
----------------看某个process id 是否拥有某种权限------------------
1.比如 BUAT 环境, 一个 opgcep1的process id
select * from dba_role_privs where GRANTEE like 'OPGCEP1';
查出 这个 opgcep1拥有哪些 权限角色
2.然后看这些权限角色是否拥有操作某些schema的权限
select * from dba_tab_privs where table_name like '%REMEDIATION4_Q%' and owner like 'BUAT_META%' AND GRANTEE = 'GCE1_DMM_UPDATE_ROLE';