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

Thread: Oracle Auditing

  1. #1
    Join Date
    Jan 2013
    Posts
    1

    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?

    Thanks!

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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.

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