Re: Listing all users for a database

The data dictionary view that you want to look at is called all_users.

Two other related views that you might be interested in are dba_users and user_users.

Try:

select * from all_users;

The all_users view has the following structure:

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

Welcome to Oracle and good luck to you.

Cheers.

Chris

Desmond Rivet wrote:

> Hi all,
>
> I'm very new to Oracle, and I'm curious on how to accomplish one thing
> inparticular. I'd like to list all the users that are allowed to
> access a particular database.
>
> I have tried the following:
>
> select * from users;
>
> but sqlplus seems to complain that the table users is non-existent. Am
> I missing something here? I can view the contents of dba_tables just
> fine, so I know I have proper permission...
>
> Thanks in advance for any help...
>
> Desmond
Received on Wed Sep 19 2001 - 20:09:24 CDT