Msg 229 Level 14 State 5 Procedure XXXXXX Line 1 The EXECUTE permission was denied on the object ‘XXXXX’, database ‘xxxxxx’, schema ‘dbo’.

Posted on : 29-05-2012 | By : Devi Prasad | In : Msg 229

0



Error Message:

Msg 229, Level 14, State 5, Procedure test, Line 1
The EXECUTE permission was denied on the object ‘test’, database ‘AdventureWorksDW2008R2’, schema ‘dbo’.

This error occurs when the user does not have execute permissions for the procedure on the database.

Fix/Resolution:
– Ask your DBA To grant you execute permissions on the procedure.

Query:

GRANT EXECUTE ON OBJECT::dbo.test TO username

Note:
dbo.test – is the procedure name
username – is the name of the user




Reference : Devi Prasad (sqlserverlearner.com)

Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.



Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.




Your Ad Here


Tags: , , , ,