Data Source: oci_data_safe_sql_firewall_policies

This data source provides the list of Sql Firewall Policies in Oracle Cloud Infrastructure Data Safe service.

Retrieves a list of all SQL Firewall policies.

The ListSqlFirewallPolicies operation returns only the SQL Firewall policies in the specified compartmentId.

The parameter accessLevel specifies whether to return only those compartments for which the requestor has INSPECT permissions on at least one resource directly or indirectly (ACCESSIBLE) (the resource can be in a subcompartment) or to return Not Authorized if Principal doesn’t have access to even one of the child compartments. This is valid only when compartmentIdInSubtree is set to true.

The parameter compartmentIdInSubtree applies when you perform ListSqlFirewallPolicies on the compartmentId passed and when it is set to true, the entire hierarchy of compartments can be returned. To get a full list of all compartments and subcompartments in the tenancy (root compartment), set the parameter compartmentIdInSubtree to true and accessLevel to ACCESSIBLE.

Example Usage

data "oci_data_safe_sql_firewall_policies" "test_sql_firewall_policies" {
	#Required
	compartment_id = var.compartment_id

	#Optional
	access_level = var.sql_firewall_policy_access_level
	compartment_id_in_subtree = var.sql_firewall_policy_compartment_id_in_subtree
	db_user_name = oci_identity_user.test_user.name
	display_name = var.sql_firewall_policy_display_name
	security_policy_id = oci_data_safe_security_policy.test_security_policy.id
	sql_firewall_policy_id = oci_data_safe_sql_firewall_policy.test_sql_firewall_policy.id
	state = var.sql_firewall_policy_state
	time_created_greater_than_or_equal_to = var.sql_firewall_policy_time_created_greater_than_or_equal_to
	time_created_less_than = var.sql_firewall_policy_time_created_less_than
	violation_action = var.sql_firewall_policy_violation_action
}

Argument Reference

The following arguments are supported:

Attributes Reference

The following attributes are exported:

SqlFirewallPolicy Reference

The following attributes are exported: