Provides the set of raw aggregated file system access data for use with Identity Governance.
Table B-1 Permission Entries Table Definition
|
Column Name |
SQL Server Data Type |
PostgreSQL Data Type |
Notes |
|---|---|---|---|
|
id |
big integer |
big integer |
Primary key |
|
scan_id |
integer |
integer |
Reference to srs.scans table |
|
target_path_id |
integer |
integer |
Reference to ig.dag_target_paths |
|
target_path |
nvarchar(max) |
text |
Target Path in UNC format |
|
target_path_hash |
binary(20) |
bytea |
SHA-1 hash of Target Path |
|
category |
nvarchar(64) |
varchar(64) |
Category assigned to Target Path |
|
trustee |
nvarchar(256) |
varchar(256) |
Trustee name in Domain\SAMAccountName format |
|
trustee_fdn |
nvarchar(256) |
varchar(256) |
Trustee full distinguished name |
|
trustee_guid |
nvarchar(36) |
varchar(36) |
Trustee GUID |
|
trustee_sid |
nvarchar(256) |
varchar(256) |
Trustee Security Identifier |
|
aggregate_access_mask |
integer |
integer |
Aggregate access mask for this identity and Target Path |
Provides static table for permissions lookup.
Table B-2 Permissions Table Definition
|
Column Name |
SQL Server Data Type |
PostgreSQL Data Type |
Notes |
|---|---|---|---|
|
id |
integer |
integer |
Primary key |
|
permission |
nvarchar(32) |
varchar(32) |
One of:
|
|
access_mask |
integer |
integer |
ACE mask that corresponds to the specific permission |
|
description |
nvarchar(128) |
varchar(128) |
Description of the permission |
Provides the set of Target Paths defined for Data Access Governance.
Table B-3 Target Paths Table Definition
|
Column Name |
SQL Server Data Type |
PostgreSQL Data Type |
Notes |
|---|---|---|---|
|
id |
integer |
integer |
Primary key |
|
target_path |
nvarchar(max) |
text |
Target Path in UNC format |
|
target_path_hash |
binary(20) |
bytea |
SHA-1 hash of Target Path |
|
scan_target_path |
nvarchar(256) |
varchar(256) |
Associated network path from srs.scan_targets |
|
category |
nvarchar(64) |
varchar(64) |
Optional category name |
|
description |
nvarchar(1024) |
varchar(1024) |
Optional description |
|
scan_id |
integer |
integer |
Reference to srs.scans table |
|
scan_time |
datetime2(0) |
timestamp without time zone |
UTC timestamp copied from scan_start_time in srs.scans |
|
process_time |
datetime2(0) |
timestamp without time zone |
UTC Time when aggregate processing completes |
|
identity_count |
integer |
integer |
Number of processed identities |
|
option_flags |
integer |
integer |
|
|
status |
integer |
integer |
|
Provides the job queue for Data Access Governance Target Path processing.
Table B-4 Target Paths Job Queue Table Definition
|
Column Name |
SQL Server Data Type |
PostgreSQL Data Type |
Notes |
|---|---|---|---|
|
id |
big integer |
big integer |
Primary key |
|
target_path_id |
integer |
integer |
Reference to ig.dag_target_paths |
|
queue_time |
datetime(2) |
timestamp without time zone |
UTC timestamp when job queued |
|
state |
integer |
integer |
|