diff options
| -rw-r--r-- | projecttemplates/RelyingPartyLogic/CreateDatabase.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/projecttemplates/RelyingPartyLogic/CreateDatabase.sql b/projecttemplates/RelyingPartyLogic/CreateDatabase.sql index 81aff9f..3e36000 100644 --- a/projecttemplates/RelyingPartyLogic/CreateDatabase.sql +++ b/projecttemplates/RelyingPartyLogic/CreateDatabase.sql @@ -144,7 +144,7 @@ AS END ELSE BEGIN - SET @roleid = (SELECT Id FROM dbo.Role WHERE [Name] = @role) + SET @roleid = (SELECT RoleId FROM dbo.Role WHERE [Name] = @role) END INSERT INTO dbo.UserRole (UserId, RoleId) VALUES (@userId, @roleid) |