Database Administration (MOSC)

MOSC Banner

Oracle DB user audit statements

edited Aug 24, 2017 5:00AM in Database Administration (MOSC) 1 commentAnswered

DB Version: 12.1

Os: Linux 6

Oracle RAC: 4 nodes

DB size: 11 TB

I need to set up an audit for one production user(prodtech) in my RAC database and have the following requirements - only when successful:

1. Need to know who is logging in as a particular production user... prodtech

2. audit alter, update, insert, delete, rename and truncate all tables in prodtech schema

3. audit procedure, function, package - execute ... prodtech schema

4. audit create, drop an index in prodtech schema

5. every time we create a new table, do I need to run a audit statement or I can create a role that would audit certain commands for the prodtech user.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center