Adding Roles Functions and Schemas
The script below can be ran to add roles, functions, and schemas to the ASPNETDB database.
USE [ASPNETDB]
GO
/****** Object: DatabaseRole [aspnet_Membership_BasicAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE ROLE [aspnet_Membership_BasicAccess]
GO
/****** Object: DatabaseRole [aspnet_Membership_FullAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE ROLE [aspnet_Membership_FullAccess]
GO
/****** Object: DatabaseRole [aspnet_Membership_ReportingAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE ROLE [aspnet_Membership_ReportingAccess]
GO
/****** Object: DatabaseRole [aspnet_Personalization_BasicAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE ROLE [aspnet_Personalization_BasicAccess]
GO
/****** Object: DatabaseRole [aspnet_Personalization_FullAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE ROLE [aspnet_Personalization_FullAccess]
GO
/****** Object: DatabaseRole [aspnet_Personalization_ReportingAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE ROLE [aspnet_Personalization_ReportingAccess]
GO
/****** Object: DatabaseRole [aspnet_Profile_BasicAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE ROLE [aspnet_Profile_BasicAccess]
GO
/****** Object: DatabaseRole [aspnet_Profile_FullAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE ROLE [aspnet_Profile_FullAccess]
GO
/****** Object: DatabaseRole [aspnet_Profile_ReportingAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE ROLE [aspnet_Profile_ReportingAccess]
GO
/****** Object: DatabaseRole [aspnet_Roles_BasicAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE ROLE [aspnet_Roles_BasicAccess]
GO
/****** Object: DatabaseRole [aspnet_Roles_FullAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE ROLE [aspnet_Roles_FullAccess]
GO
/****** Object: DatabaseRole [aspnet_Roles_ReportingAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE ROLE [aspnet_Roles_ReportingAccess]
GO
/****** Object: DatabaseRole [aspnet_WebEvent_FullAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE ROLE [aspnet_WebEvent_FullAccess]
GO
ALTER ROLE [aspnet_Membership_BasicAccess] ADD MEMBER [aspnet_Membership_FullAccess]
GO
ALTER ROLE [aspnet_Membership_ReportingAccess] ADD MEMBER [aspnet_Membership_FullAccess]
GO
ALTER ROLE [aspnet_Personalization_BasicAccess] ADD MEMBER [aspnet_Personalization_FullAccess]
GO
ALTER ROLE [aspnet_Personalization_ReportingAccess] ADD MEMBER [aspnet_Personalization_FullAccess]
GO
ALTER ROLE [aspnet_Profile_BasicAccess] ADD MEMBER [aspnet_Profile_FullAccess]
GO
ALTER ROLE [aspnet_Profile_ReportingAccess] ADD MEMBER [aspnet_Profile_FullAccess]
GO
ALTER ROLE [aspnet_Roles_BasicAccess] ADD MEMBER [aspnet_Roles_FullAccess]
GO
ALTER ROLE [aspnet_Roles_ReportingAccess] ADD MEMBER [aspnet_Roles_FullAccess]
GO
/****** Object: Schema [aspnet_Membership_BasicAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE SCHEMA [aspnet_Membership_BasicAccess]
GO
/****** Object: Schema [aspnet_Membership_FullAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE SCHEMA [aspnet_Membership_FullAccess]
GO
/****** Object: Schema [aspnet_Membership_ReportingAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE SCHEMA [aspnet_Membership_ReportingAccess]
GO
/****** Object: Schema [aspnet_Personalization_BasicAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE SCHEMA [aspnet_Personalization_BasicAccess]
GO
/****** Object: Schema [aspnet_Personalization_FullAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE SCHEMA [aspnet_Personalization_FullAccess]
GO
/****** Object: Schema [aspnet_Personalization_ReportingAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE SCHEMA [aspnet_Personalization_ReportingAccess]
GO
/****** Object: Schema [aspnet_Profile_BasicAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE SCHEMA [aspnet_Profile_BasicAccess]
GO
/****** Object: Schema [aspnet_Profile_FullAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE SCHEMA [aspnet_Profile_FullAccess]
GO
/****** Object: Schema [aspnet_Profile_ReportingAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE SCHEMA [aspnet_Profile_ReportingAccess]
GO
/****** Object: Schema [aspnet_Roles_BasicAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE SCHEMA [aspnet_Roles_BasicAccess]
GO
/****** Object: Schema [aspnet_Roles_FullAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE SCHEMA [aspnet_Roles_FullAccess]
GO
/****** Object: Schema [aspnet_Roles_ReportingAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE SCHEMA [aspnet_Roles_ReportingAccess]
GO
/****** Object: Schema [aspnet_WebEvent_FullAccess] Script Date: 4/1/2019 10:30:04 AM ******/
CREATE SCHEMA [aspnet_WebEvent_FullAccess]
GO
/****** Object: UserDefinedFunction [dbo].[bold_Helper_Base64_Decode] Script Date: 4/1/2019 10:30:04 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[bold_Helper_Base64_Decode] (@base64_text VARCHAR(max)) RETURNS VARBINARY(max)
WITH SCHEMABINDING, RETURNS NULL ON NULL INPUT
BEGIN
DECLARE @x XML; SET @x = @base64_text
RETURN (@x.value('(/)[1]', 'VARBINARY(max)'))
END
GO
/****** Object: UserDefinedFunction [dbo].[bold_Helper_Base64_Encode] Script Date: 4/1/2019 10:30:04 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[bold_Helper_Base64_Encode] (@data VARBINARY(max)) RETURNS VARCHAR(max)
WITH SCHEMABINDING, RETURNS NULL ON NULL INPUT
BEGIN
RETURN (SELECT [text()] = @data FOR XML PATH(''))
END
GO
