user650888 wrote:ALL_DEPENDENCIES will only cover the objects you have access to. If tables/views/whatever exist that you have no privileges for they will be missed by ALL_DEPENDENCIES.
If I want to know mytable is used in a select or insert everywhere across the database,
I do not have access to dba_dependencies, Is the below correct ?
I just need to know the dependent objects for mytable
where lower(NAME) like LOWER('%mytable%')
and owner not in ('SYS','SYSTEM')
order by name
select * from all_dependencies where lower(NAME) like LOWER('%employees%') and owner not in ('SYS','SYSTEM') and type = 'TABLE' order by name