Re: urgent: User list in oracle

From: christophd <christophd_at_bigfoot.com>
Date: Tue, 14 Dec 1999 16:42:13 GMT
Message-ID: <835s14$a5h$1@nnrp1.deja.com>

In article <835ps8$8cu$1_at_nnrp1.deja.com>, ylachanc_at_my-deja.com wrote:
> How do I get a list of users and groups in oracle.
>
> I found out how to create and remove users but I don't know how to get
> the list of all the users that exists on the server.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Try to query views all_users or dba_users. Browse the PUBLIC schema on your box, you'll find a lot of self explaining named and usefull views.

Ch.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 14 1999 - 10:42:13 CST