USP_DATALIST_CLIENT_ROLES

Returns list of all CMS client roles or just one by its guid.

Parameters

Parameter	Parameter Type	Mode	Description
@RoleGuid	uniqueidentifier	IN	RoleGuid

Definition

Copy



    create procedure dbo.USP_DATALIST_CLIENT_ROLES(
    @RoleGuid uniqueidentifier = null
)

as
     set nocount on;
   select 
       guid,
       ID,
           Name,
       SystemRole,
           SiteAdminRole,
           EveryoneRole,
       Deleted
    from dbo.ClientRoles
    where 
  (@RoleGuid is null)
  or
  (Guid = @RoleGuid)