11.39 idmrpt_role_v

Contains all of the roles in all of the Identity Vaults connected to the reporting tool.

role_id

VARCHAR(32)

The ID of this role in this reporting warehouse

role_dn

VARCHAR(255)

The DN of this role

role_guid

VARCHAR(64)

The GUID of this role in the Identity Vault

role_name

VARCHAR(4000)

The name of this role

role_desc

VARCHAR(4000)

The description of this role

approval_prd

VARCHAR(255)

The PRD used to grant this role

quorum

VARCHAR(8)

The quorum percentage required to gain access to this role

role_level

int2

The level of this role. The levels are 10, 20, or 30

idmrpt_valid_from

TIMESTAMP WITHOUT TIME ZONE

The date this role is valid from

idmrpt_deleted

bool

TRUE if this value is deleted and FALSE otherwise

idv_id

VARCHAR(32)

The ID of the Identity Vault containing this role

idmrpt_syn_state

int2

The sync state of this role