I have a error called "Could not find stored procedure 'usp_binarytreecustomerlist'."

SQL Server Administration
1

well the schema it uses is vedsatwa and username too as vedsatwa and the stored procedure is also there can anybody help me with it when i am trying to grant the permission then it says

script: USE Newbotan;
GRANT EXECUTE ON usp_binarytreecustomerlist TO vedsatwa;
GO

error message :
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'usp_binarytreecustomerlist', because it does not exist or you do not have permission.

2

If the schema is vedsatwa and not the default dbo you should mention it:

script: USE Newbotan;
GRANT EXECUTE ON vedsatwa.usp_binarytreecustomerlist TO vedsatwa;
GO

1 Like