Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to get all the users in the databases

Re: How to get all the users in the databases

From: <rgaston_at_epic.net>
Date: Wed, 15 Jul 1998 12:06:23 GMT
Message-ID: <6oi5vv$7sb$1@nnrp1.dejanews.com>


You could try

select username from all_users;

In article <6ohp83$o9s$1_at_nnrp1.dejanews.com>,   xiangz_at_rocketmail.com wrote:
> Hi,
>
> How to get all the accounts created in a database? Oracle Version is 7.3.3.
> I think it's in one of system tables. which table contains this information?
>
> Thanks for your help.
>
> -Xiang Zhao
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 15 1998 - 07:06:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US