Roles View

The Roles view lists all roles for each zone. This view is a combined view of the Roles_Classic and Roles_Hierarchical views.

Column Name

Description

Refers to

Role_-Always-Permit-Logon

(It will be null for classic zone’s role)

1 – always permit, 0 – not always permit

 

Role_AlwaysPermitLogon_Desc

The display value of _-Always-Permit-Logon (It will be null for classic zone’s role)

(Always permit/Not always permit)

 

Role_-Audit-Level

The role’s audit level (It will be null for classic zone’s role)

0 – audit not required, 1 – audit if possible, 2 – audit required

 

Role_AuditLevel_Desc

The display value of Role_AuditLevel (It will be null for classic zone’s role)

(Audit not Required/Audit if Possible/Audit required)

 

Role_-Description

The description of the role

 

Role_-Full-Name

The full name of the role. The format of the full name is:

<Role_Name>/<Role_ZoneName>

 

Role_-Id

The object GUID of the role

 

Role_-Name

The name of the role

 

Role_-Zone-Id

The ID of the zone where the role is defined

Zones.Zone_Id

Role_ZoneName

The name of the zone where the role is defined

 

Roles columns used in other views

Column name

Referred from other view

Roles.Right_GUID

ZoneRolePrivileges.ZoneRolePrivileges_RightGUID

Roles.Role_Id

EffectiveUserPrivileges_Computer.Role_GUID

EffectiveUserPrivileges_ComputerRole.Role_GUID

EffectiveUserPrivileges_Zone.Role_GUID

RoleAssignments_ComputerRole.RoleAssignment_RoleGUID

ZoneRolePrivileges.ZoneRolePrivileges_RoleGUID