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

Share:

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:
[sql]
GRANT EXECUTE ON OBJECT::dbo.test TO username
[/sql]
Note:
dbo.test – is the procedure name
username – is the name of the user




References : Devi Prasad (sqlserverlearner.com)

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.


Do you like my blog?

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




Write a comment



Tags: , , , ,