"DeleteUserRole" 存储过程

描述:

This 存储过程 deletes a user from the specified security role. Roles are defined on a per-portal basis in the Roles table.

定义:

    
    CREATE PROCEDURE DeleteUserRole
    (
        @UserID int,
        @RoleID int
    )
    AS

    DELETE FROM
        UserRoles

    WHERE
        UserID=@UserID
        AND
        RoleID=@RoleID

使用的数据库中的表:

UserRoles: The UserRoles table provides a many-to-many connection between portal security roles (defined in the Roles table) and users (defined in the Users table). Using the UserRoles table, each user may belong to multiple roles and and each role may have multiple users as members.

The UserRoles table has no primary key.