select owner,object,type,con_id from V$ACCESS
where owner not in ('SYS','DBSNMP','GSMADMIN_INTERNAL','PUBLIC','SYSTEM','XDB')
group by owner,object,type,con_id
order by owner, object
Odkazy
Rubriky
select owner,object,type,con_id from V$ACCESS
where owner not in ('SYS','DBSNMP','GSMADMIN_INTERNAL','PUBLIC','SYSTEM','XDB')
group by owner,object,type,con_id
order by owner, object