Re: T-SQL Debugger Error
- From: "Greg D. Moore \(Strider\)" <mooregr_deleteth1s@xxxxxxxxxxx>
- Date: Wed, 25 Apr 2007 11:58:58 GMT
"Rahul" <verma.career@xxxxxxxxx> wrote in message
news:1177496846.397898.39610@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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.
Correct. sp_sdidebug is in the master database and you're most likely in a
different database.
Generally user written stored procs should NOT have their names start with
sp_ because SQL Server handles those a bit differently (including basically
making them "publically" available from the master db.)
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
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
.
- References:
- T-SQL Debugger Error
- From: Rahul
- T-SQL Debugger Error
- Prev by Date: Re: T-SQL Debugger Error
- Next by Date: Re: Optional Where Parameters on Null Data
- Previous by thread: Re: T-SQL Debugger Error
- Next by thread: T-SQL Debugger Error
- Index(es):
Relevant Pages
|
