Posted by Rahul on 04/25/07 10:27

Hi,

When I debug our sp by using T-SQL Debugger, I got following error.

Server: Msg 229, Level 14, State 5, Procedure sp_sdidebug, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission
denied on object 'sp_sdidebug', database 'master', owner 'dbo'.


and when I grant the permission of sp_sdidebug, I got following error.

Server: Msg 4610, Level 16, State 1, Line 1
You can only grant or revoke permissions on objects in the current
database.


I am using following statement to grant the permission.

GRANT EXECUTE
ON sp_sdidebug
TO myuser

Here, I want to clear, myuser is I, which one i log QA.
and myuser has public and dbowner permission

--
Rahul

• Next in forum: T-SQL Debugger Error
• Prev in forum: Re: Update trigger or ?
• Thread view: T-SQL Debugger Error

[Reply to this message]