Greetings all,
What are the prerequisites for enabling and disabling a trigger inside a stored procedure.
I'm running the following code and my application is saying: "User does not have permissions to perform this operation on table DockCrewImportErrors"
ALTER
TABLE DockCrewImportErrorsDISABLE
TRIGGER trg_UpdateValidation
It runs without error in query analyzer when I call the stored procedure with the above code inside.
I granted permissions to Public on the table.
What am I missing
Thanks,
Adamus