Scenario:
We have application schema with dba priv to be audited and restricted from toad like programs.
But if you enable audit to application schema it will effect performance of the application in day as well as in EOD process.
So you want to do audit other activity of normal user through and Restrict direct access to the schema from toad like programs.
1.Cloning dba role to new dba role,Since log on trigger will not work for dba users.
2.Grant new dba role to application schema.
3.Revoke standard dba role from application schema.
3.Creating log on trigger and role to block toad like program access through direct login.
4.Create Normal user and assign log on trigger.
5.Enable audit to normal schema.
We have application schema with dba priv to be audited and restricted from toad like programs.
But if you enable audit to application schema it will effect performance of the application in day as well as in EOD process.
So you want to do audit other activity of normal user through and Restrict direct access to the schema from toad like programs.
1.Cloning dba role to new dba role,Since log on trigger will not work for dba users.
2.Grant new dba role to application schema.
3.Revoke standard dba role from application schema.
3.Creating log on trigger and role to block toad like program access through direct login.
4.Create Normal user and assign log on trigger.
5.Enable audit to normal schema.
