User Info SQL


--
--        userinfo.sql
--

set pagesize 66
set verify off
set feedback off

ttitle 'User Information'
col username        format a12        heading 'User Name'
col created                        heading 'Created'
col col1        format a16        heading 'Roles'
col col2        format a16        heading 'Default TS'
col col3        format a16        heading 'Temporary TS'

break on username skip

spool userinfo.lst

select username, created, substr(granted_role, 1, 15) col1,
default_tablespace col2, temporary_tablespace col3
from sys.dba_users, sys.dba_role_privs
where username = grantee(+)
order by username
/

spool off
set verify on
set feedback on
exit