DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Oracle Auditing

  1. #1
    Join Date
    Jan 2013

    Oracle Auditing

    Hello everybody!
    I work on application that collects Oracle events.
    In order for the application to collect and process Oracle events, the account which is being used by the application service requires the 'SYSDBA' server role.
    There are some situations where the customer cannot give 'SYSDBA’ permissions to this account for security reasons. The question is can more restrictive privileges be configured in order to do that?


  2. #2
    Join Date
    Nov 2000
    Pittsburgh, PA
    You can create a wrapper package owned by sys, and then grant execute right on that package to whoever needs it. you would be presenting just the methods that you want to present. And you can verify the inputs within the wrapper package.
    this space intentionally left blank

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.