var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: creating trigger
I have an acount which can perform any DML activity to another user object. If I create a after insert trigger of the another user table in the current schema I am facing Insufficient privilage. I am using username.objectname. My oracle version is 9i and os is windows 2000
Can any body tell we what is the issue?
Thanks in advance.
Re: creating trigger
Do you have ... "CREATE ANY TRIGGER" privileges?
Yes a user have create any trigger privilages..
as far as I know you cannot create a trigger on a table unless you are the owner of the table.
I am almost certain that the trigger code needs to reside in the same schema as the data.
Can you modify the table from the other schema?
if not ensure that the user has the priviledge to alter the table.
grant alter on table to user
hope this is of some help
I am not certain that "create any DML" (data manipulation language i.e. inserts, updates, etc) includes "create any trigger" which I believe is DDL. Try explicitly granting "create any trigger"