betweenGo

List users

by on Aug.08, 2008, under Oracle

To list all the users in a database log in as the sysadmin and query the dba_users table.

$ sqlplus sysman/123456@dev01

SQL> select username from dba_users where username like 'Frank%';


Share

Related posts:

  1. Determining Permissions for a User
  2. ORA-12514 and ORA-27101
  3. How to Retrieve Oracle Version Information
  4. Retrieving the Source from the Database
  5. How to Import and Create Users in Oracle

:

Leave a Reply

 

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!