SQL Script Database User Account Listing

Updated: 20-May-2003
Version: 1.0

Description

This script lists the database user details and their status.

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 


set pages 200

col username form a10
col temporary_tablespace form a15
col default_tablespace form a15
col account_status form a20

spool dbuser.lst

select username
     , temporary_tablespace
     , default_tablespace
     , account_status
     , created
from dba_users;


spool off

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links