Dba Users

Description: Returns user details.

SET pages 60
SET lines 80
col username format a10
col default_tablespace format a20
col temporary_tablespace format a20
col profile format a10
SELECT username,default_tablespace,temporary_tablespace,profile
FROM dba_users
/

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.