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

(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.
> >
>
>
Received on Mon May 06 2002 - 04:42:18 CDT