Query on Trigger

[suvam]

Can ny one tell me that
suppose a table T1 has been granted access for all users in a database .
Now the table T1 has a DML trigger TR1 , which has been granted access for only one user(owner of the table) .
Now if any DML is issued on T1 , then whether TR1 will execute or not ??

[pragatiswain]

Can ny one tell me that
suppose a table T1 has been granted access for all users in a database .
Now the table T1 has a DML trigger TR1 , which has been granted access for only one user(owner of the table) .
Now if any DML is issued on T1 , then whether TR1 will execute or not ??

TR1 will execute only for that user having access on the trigger.

[buzznt]

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