Page History
...
DECLARE @UserId INT
DECLARE @ApplicationId INT
DECLARE @RoleId INT
SET @ApplicationId = 3
SET @RoleId = (SELECT AR.ID FROM [Common].[ApplicationRoles] as AR WHERE AR.AppID = 3 AND AR.Name = N'Admin')
SET @UserId = (SELECT TOP 1 US.ID FROM [Common].[Users] as US WHERE US.UserName <> N'ServiceUser' AND US.Active = 1 AND US.UserType = N'U')
INSERT INTO [Common].[ApplicationUsers] ([UserID],[ApplicationID]) VALUES (@UserId,@ApplicationId)
INSERT INTO [Common].[ApplicationUserRoles]([UserID],[AppID],[RoleID]) VALUES (@UserId ,@ApplicationId , @RoleId)
Scroll pdf ignore | |||||||
---|---|---|---|---|---|---|---|
IDERA Website | Products | Purchase | Support | Resources | Community | About Us | Legal |
...