Skip to Content

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


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 .


pl help.


Former Member

use select * from DBA_USERS;

For Securty parameters check the Oracle Profiles.

select * from dba_profiles;


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