users

[Former Member]

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 · Accepted solution]

Hi,

use select * from DBA_USERS;

For Securty parameters check the Oracle Profiles.

select * from dba_profiles;

You will get the parameters.

Thanks,

Shambo

[Former Member · Accepted solution]

Hi Friends,

Thanks for the reply,

When i have executed the statement select * from all_users; i have got the following list of users

SYS

SYSTEM

OUTLN

DIP

TSMSYS

DBSNMP

OPS$ORA<SID>

OPS$<SID>ADM

SAPSR3

OPS$SAPSERVICE<SID>

How can we find out who has access to the above users in the system, this is required for the audit.

Please someone help .

thanks,

anurop

[Former Member · Accepted solution]

Hi

Go for SM19 and SM20 for audit purpose

Regards

Bhaskar

[Former Member · Accepted solution]

Hi,

Are you asking about the Oracle level audit ?

[Former Member · Accepted solution]

Yes it is SAP - Oracle level audit. pl help the same.

thanks

[Former Member · Accepted solution]

use select * from DBA_USERS;

For Securty parameters check the Oracle Profiles.

select * from dba_profiles;

Thanks

[lakshminarayanan_m · Accepted solution]

Hi,

Your audit is based on sap or oracle , generaly sap - user details will audit . Oracle user wont audit. But we have to lock the user. The users are follows,

OUTLN

DIP

TSMSYS

DBSNMP.

And we should have respective roles for the other users.

Regards

MLN

Edited by: Lakshminarayanan M on Oct 20, 2008 1:26 PM