"GetRoleMembership" Stored Procedure

This stored procedure returns all of the users who are members of the specified portal security role. The input parameter is the RoleID.

    
    CREATE PROCEDURE GetRoleMembership
    (
        @RoleID  int
    )
    AS

    SELECT  
        UserRoles.UserID,
        Name,
        Email

    FROM
        UserRoles
        
    INNER JOIN 
        Users On Users.UserID = UserRoles.UserID

    WHERE   
        UserRoles.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.