Alter Table Permissions
As part of a stored procedure, I use ALTER TABLE to disable a trigger.
I am getting the error "User does not have permission to perform this operation on table 'tablename'."
The dbUser I have connecting has SELECT, UPDATE, INSERT and DELETE permissions on the table. What do I need to do in order for the procedure to disable the trigger?
Thanks in advance for your comments.
- - - - - - - - - - - - - - - - - - - - - - -
In God we trust, everything else we test.
|
