betweenGo

List users

by Frank Kim 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/Bookmark

Related posts:

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

:

Comments are closed.

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!