Re: How to list the user logins present in the database

"George Barbour" <gbarbour_at_csc.com> wrote in message news:<3cd64fc9$1_at_pull.gecm.com>...
> (note to me: read the question Geo).
>
> View's for "logged on" users are v$session and v$process.
> e.g. select * from v$session; although dba's tend to have their own
> scripts to monitor their instances.
>
> George Barbour.
>
> "George Barbour" <gbarbour_at_csc.com> wrote in message
> news:3cd64ec9_at_pull.gecm.com...
> > Depends what you need start from :-
> > select * from dba_users;
> > BTW you kinda get flamed in here for not reading the Oracle manual.
> >
> > George Barbour.
> >
> > "Shravan Kumar" <Shravan.Kumar_at_icn.siemens.de> wrote in message
> > news:3CD638EF.73CE3048_at_icn.siemens.de...
> > > Hi All,
> > >
> > > I am new to oracle.
> > >
> > > simple question : what is the sql command used to list the user accounts
> > > that are present in a database.
> > >
> > > we are using oracle 9.0.1 on solaris 8.
> > >
> > > thanks,
> > >
> > > Best Regards,
> > > Shravana Kumar.
> > >
> >
> >

Select username from dba_users;  

Michael Tubuo Ngong (Sr DBA) Received on Mon May 06 2002 - 10:51:24 CDT