Re: Listing all users for a database

From: Dale Edgar <dale_at_databee.com>
Date: Wed, 19 Sep 2001 15:53:08 GMT
Message-ID: <3ba8beea.1664410@news.btclick.com>

Hi Desmond

On 19 Sep 2001 07:49:19 -0700, rivet_d_at_hotmail.com (Desmond Rivet) wrote:
>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.

Have a look at DBA_USERS. You can also look in V$SESSION to see who is currently connected to the database.

Regards
Dale

---

DataBee - The simple and easy way to create small versions of large Oracle databases. http://www.databee.com Received on Wed Sep 19 2001 - 10:53:08 CDT