List users Posted on August 8, 2008 by Frank Kim 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%'; Related posts: Determining Permissions for a User ORA-12514 and ORA-27101 How to Retrieve Oracle Version Information Retrieving the Source from the Database How to Import and Create Users in Oracle