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)
|