T-SQL Debugger Error

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

.

Relevant Pages

  • Re: T-SQL Debugger Error
    ... denied on object 'sp_sdidebug', database 'master', owner 'dbo'. ... and when I grant the permission of sp_sdidebug, ... I am using following statement to grant the permission. ...
    (comp.databases.ms-sqlserver)
  • RE: Security context of stored procedure
    ... Suppose there are three users in a database TEST_CHAIN, ... simple stored procedure: ... also grant it to test_sp2 ... SELECT permission denied on object 'authors', database 'test_chain', owner ...
    (microsoft.public.sqlserver.security)
  • Re: GRANT BACKUP DATABASE
    ... I grant to one user the permission to backup one database but now i cant ...
    (microsoft.public.sqlserver.server)
  • T-SQL Debugger Error
    ... denied on object 'sp_sdidebug', database 'master', owner 'dbo'. ... and when I grant the permission of sp_sdidebug, ... I am using following statement to grant the permission. ... Here, I want to clear, myuser is I, which one i log QA. ...
    (comp.databases.ms-sqlserver)
  • T-SQL Debugger Error
    ... denied on object 'sp_sdidebug', database 'master', owner 'dbo'. ... and when I grant the permission of sp_sdidebug, ... I am using following statement to grant the permission. ... Here, I want to clear, myuser is I, which one i log QA. ...
    (comp.databases.ms-sqlserver)