use master
go
exec sp_addrole 'debuger'
go
use master
go
grant execute on master.dbo.sp_sdidebug to debuger
go
use master
exec sp_grantdbaccess 'NavTech'
go
exec sp_addrolemember N'debuger', N'NavTech'
go
use master
go
exec sp_addrole 'debuger'
go
use master
go
grant execute on master.dbo.sp_sdidebug to debuger
go
use master
exec sp_grantdbaccess 'NavTech'
go
exec sp_addrolemember N'debuger', N'NavTech'
go