Auditting requirements

We have a project where we randomly create oracle accounts based on user requests. The requirement is that as soon as a user is created we need to enable auditting for the newly created user.

To enable auditting we need to run commands like this:

audit all by <acct> by access;
audit alter sequence by <indiv acct> by access; audit alter table by <acct> by access;
audit comment table by <cct> by access;
audit grant procedure by <acct> by access; audit grant sequence by <acct> by access; audit grant table by <acct> by access;
audit grant type by <acct> by access;
audit lock table by <acct> by access;

What we are thinking of doing is to program this into our code where the user gets created.
But we have a lot of databases to which we will have to connect to and run these commands as a procedure.

Hence, I want to explore if that can be done using oracle auditting commands. Like can iI enable auditting for all users by default (or a subset) so that a new user created will have auditting enabled whenever his account gets created? Or can I have the above commands run as soon as (after) a user-account is created? Is that possible?

It wd be great if someone can help me as I am a n00b in this field.

Thanks in advance,
Anoop Received on Wed Jun 21 2006 - 14:09:19 CDT