Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Listing all users for a database
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:49:19 CDT