This stored procedure returns all of the security roles for the specified portal. The input parameter is the PortalID.
Definition:CREATE PROCEDURE GetPortalRoles ( @PortalID int ) AS SELECT RoleName, RoleID FROM Roles WHERE PortalID = @PortalIDDatabase 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.