Subject Area : 290 - Security
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 290 - Security Security tables used to store XACML permissions. Details.. Details..
ER Diagram(s) of Subject Area "290 - Security"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "290 - Security"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 3
. secuty_policy Security Policy false A XACML security policy. Details..
. target_match Target Match false Matches the Securty Policy to a Target using XACML rules. Details..
. target_match_type Target Match Type false A lookup table for the XACML target match type. Values include ACTION, RESOURCE, SUBJECT Details..
Attribute/Column(s) of Entity/Table "Security Policy"
# Physical Name Name Definition Physical Data Type
Total 5
. 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
Attribute/Column(s) of Entity/Table "Target Match"
# Physical Name Name Definition Physical Data Type
Total 7
. 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
Attribute/Column(s) of Entity/Table "Target Match Type"
# Physical Name Name Definition Physical Data Type
Total 2
. 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)