# "UpdateRole" Stored Procedure

Description:

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 Portal_UpdateRole
       (
           @RoleID      int,
           @RoleName    nvarchar(50)
       )
       AS

       UPDATE Portal_Roles

       SET
           RoleName = @RoleName

       WHERE
           RoleID = @RoleID

Database 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.