Database Administration (MOSC)

MOSC Banner

Can I enable auditing just for sysdba?

in Database Administration (MOSC) 10 commentsAnswered

Hi all, recently during an internal audit. I've been requested to enable auditing for some of my Oracle databases. We have several version of Oracle, mainly 11g & 10g.

I notice that the database has standard auditing enabled but audit_sys_operations isn't enabled. I know that to enable sysdba audit I just need to enable that parameter.

However my developer also mention that there's no need to audit non-sysdba users in the DB. Reason given is their applications has it's own way of auditing non-sysdba users & the additional auditing by Oracle is causing some performance issue whenever their applications doing heavy inserts.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center