Re: Listing all users for a database

From: Matthias Gresz <nospam_at_newsranger.com>
Date: Wed, 19 Sep 2001 14:53:05 GMT
Message-ID: <lj2q7.5706$p77.18877@www.newsranger.com>

In article <99f4b1ca.0109190649.73659da9_at_posting.google.com>, Desmond Rivet says...
Try all_users, dba_users

Matthias

>
>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 - 09:53:05 CDT