Oracle DB user audit statements
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.