"GetPortalRoles" 存储过程

描述:

This 存储过程 returns all of the security roles for the specified portal. The input parameter is the PortalID.

定义:

        
    CREATE PROCEDURE GetPortalRoles
    (
        @PortalID  int
    )
    AS

    SELECT  
        RoleName,
        RoleID

    FROM
        Roles

    WHERE   
        PortalID = @PortalID

使用的数据库中的表:

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.