A DML trigger created by the owner of the table will always be performed. The only limitations are if the trigger issues SQL statements or calls procedures or functions, then the owner of the trigger must have the privileges necessary to perform these operations. These privileges must be granted directly to the owner rather than acquired through roles.
Have fun.....
Roni
buzznt
Last Activity: Dec 7 '06, 07:44 AM
Joined: Dec 6 '06
Location:
-
There is no track on which user created which database object unless U activate the "audit" option (taking into account that it will effect your DB performance) and then get a log for every operation in the DB.
Only take into account that only users with DBA privilege can create datafile.
10X,
RoniLeave a comment:
-
HI :)
One solution is to use in the script connect string inside you script, like:
10X,Code:sqlplus sqlplus -s /nolog << *EOF* conn <user>/<pass> ..... <SQL> ..... *EOF*
Roni...Leave a comment:
No activity results to display
Leave a comment: