Zaaker's Oracle DBA Blog
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment