Re: Listing all users for a database

Try table fnd_users.
If that table isn't known either just do the following select to hve a list of the tables related to ' users':

Select *
from cat
where table_name like '%USER%';

This wil retrieve all the tables that have the syntax USER in it (do it uppercase), and hopefully you hav located the users table.

You can also look at the table dba_objects, it need a bit more knoledgement but it may help you out to expore the objects.

Keep cool.

E. Received on Thu Sep 20 2001 - 14:34:43 CDT