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: MotoX <rat_at_tat.a-tat.com>
Date: Wed, 15 Jul 1998 10:08:43 +0100
Message-ID: <900493643.27824.0.nnrp-07.c2de712e@news.demon.co.uk>


try: 'select username from dba_users;'

xiangz_at_rocketmail.com wrote in message <6ohp83$o9s$1_at_nnrp1.dejanews.com>...
>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
Received on Wed Jul 15 1998 - 04:08:43 CDT

Original text of this message

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