Base Oracle Userid applicability
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Base Oracle Userid applicability

  1. #1
    Join Date
    Jul 2005
    Posts
    1

    Question Base Oracle Userid applicability

    Dear all;

    first many thanks in advance and I used to be a techie (IBM SysProg) so please forgive my question which negates everything I used to live for.

    ORACLE - AIX environment

    Internal Audit have demanded that our Oracle DBA's not use the Base Oracle Userid and Password (naturally the password has been changed but...), and they assign themselves Userids with appropriate rights. No problems you would think, ha, the Oracle DBA's are very specific on this:

    they state they need the Oracle account to do the following:

    - starting the listener
    - Modifing configuration files like tnsnames.ora, listener.ora, init file and others
    - Handling of the database archive logs
    - Troubleshooting backup/recovery problems and issues
    - Applying Oracle patches
    - Clean up of oracle UNIX allocated resources

    As far as I am aware they are wrong and it is possible to assign individual Userids with the appropriate rights to do these functions;

    Now I know many will think - you can't ask us to answer this, we demand access - but like I say I used to be a techie and I do understand, however the proper answer would be gratefully received.

    As for the Oracle documention, ha ha ha ha - it seems to have magically disappeared...


    Many thanks in advance
    Kindest regards
    Sean

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    - starting the listener

    nope

    - Modifing configuration files like tnsnames.ora, listener.ora, init file and others

    can be done with group permissions

    - Handling of the database archive logs

    what kind of handling?

    - Troubleshooting backup/recovery problems and issues

    Dont need oracle account for that

    - Applying Oracle patches

    definitely need oracle access for that

    - Clean up of oracle UNIX allocated resources

    need oracle access or root

    the docs are are http://tahiti.oracle.com or http://otn.oracle.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width