This stored procedure is used by the Roles administration page to update the display name of the specified role. The input parameter is the RoleID.
Definition:CREATE PROCEDURE UpdateRole ( @RoleID int, @RoleName nvarchar(50) ) AS UPDATE Roles SET RoleName = @RoleName WHERE RoleID = @RoleIDDatabase Tables Used:
Roles: Each record in the Roles table defines a unique role in the selected portal. Users are added to a role via the UserRoles lookup value table.
The primary key in this table is the RoleID identity field.