代码改变世界

Oracle - How To Query If A User Has Execute Privilege on DBMS_LOB

2022-02-07 11:16  jetwill  阅读(14)  评论(0编辑  收藏  举报
select grantee, owner, table_name, grantor, privilege, type
  from dba_tab_privs 
 where table_name='DBMS_LOB';

select owner, object_type, object_name, status, last_ddl_time
  from all_objects
 where object_name in ('XXX', 'YYY');