Self-service Data Alerts in SSRS 2012 - Learning SQL Server Reporting Services 2012 - page 372

if not exists (select * from sysusers where issqlrole = 1 and name =
'RSExecRole')
BEGIN
EXEC sp_addrole 'RSExecRole'
END
GO
DECLARE @AccountName nvarchar(260)
SET @AccountName = SUSER_SNAME(0x010500000000000515000000b243564b496c6
d2a8c486941e8030000)
DECLARE @name_in_db nvarchar(260)
select @name_in_db = sysusers.name from sysusers inner join master.
dbo.syslogins logins on logins.sid = sysusers.sid where logins.name =
@AccountName and logins.isntname = 1
if @name_in_db IS NULL
BEGIN
EXEC sp_grantdbaccess @AccountName, @name_in_db OUTPUT
END
IF @name_in_db IS NOT NULL AND @name_in_db != 'dbo' AND @name_in_db !=
'sys'
BEGIN
EXEC sp_addrolemember 'RSExecRole', @name_in_db
END
GO
USE [ReportingService_b67933dba1f14282bdf434479cbc8f8fTempDB]
GO
if not exists (select * from sysusers where issqlrole = 1 and name =
'RSExecRole')
BEGIN
EXEC sp_addrole 'RSExecRole'
END
GO
DECLARE @AccountName nvarchar(260)
SET @AccountName = SUSER_SNAME(0x010500000000000515000000b243564b496c6
d2a8c486941e8030000)
DECLARE @name_in_db nvarchar(260)