Thursday, August 13, 2015

Oracle : Script reports the names of all ORACLE usernames that own database objects

col owner format a33 heading 'Owner Name' justify c

select
  distinct owner
from
  dba_objects
where
  owner not in ('SYS')
order by
  1 asc

No comments:

Post a Comment