Execute Procedure failed With Error: Error message:Procedure:The user does not have UPDATE, INSERT or DELETE access to table.
I am very poor at Stored procedures.I have a quick question on the Access rights while executing the procedure.
One of my DBA Created a Stored procedure(stored proc is to release the Mload Locks, to drop the Error and log tables ) under different database.My DBA left the Complany and his ID got dropped.My Procedure rans successfully , before the Creator Dropped.While we execute the Procedure after the creator dropped, it failed with the below error.
TPT_CLEANUP:Creator 'DBA_ID' of the stored procedure 'Procedure_Name' does not exist.Unable to get catalog string
Please help us out.
The DBA who left has created many procedure under the different databases. As his ID got dropped will all the rremaing Procs will fail with this issues?