Find users

[zircon06]

Can anyone tell me sql command to find users in the database

Thanks

 

[KenCunningham]

Active users? Try querying username in v$session.

I want to be good, is that not enough?

 

[DrD123]

Hi zircon06,

You want all possible users in the dB?

For this you'll need access to sys's tables/views:

select name from sys.user$;

To add in other columns/fields to your select, get them from:

desc sys.user$

Good luck
DrD

 

[SantaMufasa]

...Or, as an alternative:

desc all_users

Name                    Null?    Type
----------------------- -------- ------------
USERNAME                NOT NULL VARCHAR2(30)
USER_ID                 NOT NULL NUMBER
CREATED                 NOT NULL DATE

select * from all_users;

USERNAME      USER_ID CREATED
---------- ---------- ---------
SYS                 0 14-SEP-03
SYSTEM              5 14-SEP-03
OUTLN              11 14-SEP-03
DBSNMP             19 15-SEP-03
DHUNT              21 15-SEP-03
YADA              110 07-FEB-07
...

Let us know if this is what you wanted.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[zircon06]

As always thanks Mufasa for your advice

 

[SantaMufasa]

You are welcome.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]