Re: Looking for list of oracle users

Hi,

if you are logged in as any old user to the database then

select username from all_users;

in SQL*Plus, if you have a DBA account then you can also do

select username from dba_users;

have a look at my website http://www.petefinnigan.com/orasec.htm there is a couple of papers I wrote that give lists of the default users and their passwords that can be installed.

hth

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.