Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 04, 2008 at 02:18 PM

    Hi,

    use select * from DBA_USERS;

    For Securty parameters check the Oracle Profiles.

    select * from dba_profiles;

    You will get the parameters.

    Thanks,

    Shambo

    Add comment
    10|10000 characters needed characters exceeded

    • 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