Subject Area : 290 - Security
Subject Area Name Definition
290 - Security Security tables used to store XACML permissions.
ER Diagram Name Physical Display Level
Logical Column
Physical Column
Physical Name Entity/Table Name Logical Only Do Not Generate Definition
secuty_policy Security Policy false A XACML security policy.
Physical Name Attribute/Column Name Definition Physical Data Type
secuty_policy_id Security Policy Id The automatically generated primary key of the secuty_policy table. bigint
policy_id Policy Id Policy Id varchar(255)
policy_content Policy Content xml blob with the content of the XACML policy varchar(max)
create_date Create Date Create Date datetime
delete_date Delete Date Logical Delete date datetime
target_match Target Match false Matches the Securty Policy to a Target using XACML rules.
Physical Name Attribute/Column Name Definition Physical Data Type
target_match_id Target Match Id The automatically generated primary key of the target_match table. bigint
secuty_policy_id Security Policy Id A Foreign Key to the Security Policy table. bigint
target_match_type_name Target Match Type Name The name of the Target Match Type. Values include Action, Resource, Subject. varchar(70)
attr_id Attribute Id Concatenated identifier of the target attribute name in a name/value pair. varchar(70)
attr_val Attribute Value The value of the name/value pair. varchar(70)
create_date Create Date Create date. datetime
delete_date Delete Date Logical Delete date. datetime
target_match_type Target Match Type false A lookup table for the XACML target match type. Values include ACTION, RESOURCE, SUBJECT
Physical Name Attribute/Column Name Definition Physical Data Type
target_match_type_name Target Match Type Name The name of the Target Match Type. Values include Action, Resource, Subject. VARCHAR(70)
target_match_type_descr Target Match Type Description A descriptive name of the Target Match Type. This descriptive name may be localized. varchar(512)