Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

users

Hi ,

I am trying to find all the users in oracle, i am aware of the oracle statement that is

select * from all_users; , is there any other statement to find all the users in oracle.

Does any one know how we can find list of any oracle parameters that are associated with the security .

thanks,

pl help.

anuroop

Former Member
replied

use select * from DBA_USERS;

For Securty parameters check the Oracle Profiles.

select * from dba_profiles;

Thanks

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question