1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DataSafe
  5. getSqlFirewallPolicies
Oracle Cloud Infrastructure v2.30.0 published on Monday, Apr 14, 2025 by Pulumi

oci.DataSafe.getSqlFirewallPolicies

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.30.0 published on Monday, Apr 14, 2025 by Pulumi

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

import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testSqlFirewallPolicies = oci.DataSafe.getSqlFirewallPolicies({
    compartmentId: compartmentId,
    accessLevel: sqlFirewallPolicyAccessLevel,
    compartmentIdInSubtree: sqlFirewallPolicyCompartmentIdInSubtree,
    dbUserName: testUser.name,
    displayName: sqlFirewallPolicyDisplayName,
    securityPolicyId: testSecurityPolicy.id,
    sqlFirewallPolicyId: testSqlFirewallPolicy.id,
    state: sqlFirewallPolicyState,
    timeCreatedGreaterThanOrEqualTo: sqlFirewallPolicyTimeCreatedGreaterThanOrEqualTo,
    timeCreatedLessThan: sqlFirewallPolicyTimeCreatedLessThan,
    violationAction: sqlFirewallPolicyViolationAction,
});
Copy
import pulumi
import pulumi_oci as oci

test_sql_firewall_policies = oci.DataSafe.get_sql_firewall_policies(compartment_id=compartment_id,
    access_level=sql_firewall_policy_access_level,
    compartment_id_in_subtree=sql_firewall_policy_compartment_id_in_subtree,
    db_user_name=test_user["name"],
    display_name=sql_firewall_policy_display_name,
    security_policy_id=test_security_policy["id"],
    sql_firewall_policy_id=test_sql_firewall_policy["id"],
    state=sql_firewall_policy_state,
    time_created_greater_than_or_equal_to=sql_firewall_policy_time_created_greater_than_or_equal_to,
    time_created_less_than=sql_firewall_policy_time_created_less_than,
    violation_action=sql_firewall_policy_violation_action)
Copy
package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/datasafe"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := datasafe.GetSqlFirewallPolicies(ctx, &datasafe.GetSqlFirewallPoliciesArgs{
			CompartmentId:                   compartmentId,
			AccessLevel:                     pulumi.StringRef(sqlFirewallPolicyAccessLevel),
			CompartmentIdInSubtree:          pulumi.BoolRef(sqlFirewallPolicyCompartmentIdInSubtree),
			DbUserName:                      pulumi.StringRef(testUser.Name),
			DisplayName:                     pulumi.StringRef(sqlFirewallPolicyDisplayName),
			SecurityPolicyId:                pulumi.StringRef(testSecurityPolicy.Id),
			SqlFirewallPolicyId:             pulumi.StringRef(testSqlFirewallPolicy.Id),
			State:                           pulumi.StringRef(sqlFirewallPolicyState),
			TimeCreatedGreaterThanOrEqualTo: pulumi.StringRef(sqlFirewallPolicyTimeCreatedGreaterThanOrEqualTo),
			TimeCreatedLessThan:             pulumi.StringRef(sqlFirewallPolicyTimeCreatedLessThan),
			ViolationAction:                 pulumi.StringRef(sqlFirewallPolicyViolationAction),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}
Copy
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testSqlFirewallPolicies = Oci.DataSafe.GetSqlFirewallPolicies.Invoke(new()
    {
        CompartmentId = compartmentId,
        AccessLevel = sqlFirewallPolicyAccessLevel,
        CompartmentIdInSubtree = sqlFirewallPolicyCompartmentIdInSubtree,
        DbUserName = testUser.Name,
        DisplayName = sqlFirewallPolicyDisplayName,
        SecurityPolicyId = testSecurityPolicy.Id,
        SqlFirewallPolicyId = testSqlFirewallPolicy.Id,
        State = sqlFirewallPolicyState,
        TimeCreatedGreaterThanOrEqualTo = sqlFirewallPolicyTimeCreatedGreaterThanOrEqualTo,
        TimeCreatedLessThan = sqlFirewallPolicyTimeCreatedLessThan,
        ViolationAction = sqlFirewallPolicyViolationAction,
    });

});
Copy
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DataSafe.DataSafeFunctions;
import com.pulumi.oci.DataSafe.inputs.GetSqlFirewallPoliciesArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var testSqlFirewallPolicies = DataSafeFunctions.getSqlFirewallPolicies(GetSqlFirewallPoliciesArgs.builder()
            .compartmentId(compartmentId)
            .accessLevel(sqlFirewallPolicyAccessLevel)
            .compartmentIdInSubtree(sqlFirewallPolicyCompartmentIdInSubtree)
            .dbUserName(testUser.name())
            .displayName(sqlFirewallPolicyDisplayName)
            .securityPolicyId(testSecurityPolicy.id())
            .sqlFirewallPolicyId(testSqlFirewallPolicy.id())
            .state(sqlFirewallPolicyState)
            .timeCreatedGreaterThanOrEqualTo(sqlFirewallPolicyTimeCreatedGreaterThanOrEqualTo)
            .timeCreatedLessThan(sqlFirewallPolicyTimeCreatedLessThan)
            .violationAction(sqlFirewallPolicyViolationAction)
            .build());

    }
}
Copy
variables:
  testSqlFirewallPolicies:
    fn::invoke:
      function: oci:DataSafe:getSqlFirewallPolicies
      arguments:
        compartmentId: ${compartmentId}
        accessLevel: ${sqlFirewallPolicyAccessLevel}
        compartmentIdInSubtree: ${sqlFirewallPolicyCompartmentIdInSubtree}
        dbUserName: ${testUser.name}
        displayName: ${sqlFirewallPolicyDisplayName}
        securityPolicyId: ${testSecurityPolicy.id}
        sqlFirewallPolicyId: ${testSqlFirewallPolicy.id}
        state: ${sqlFirewallPolicyState}
        timeCreatedGreaterThanOrEqualTo: ${sqlFirewallPolicyTimeCreatedGreaterThanOrEqualTo}
        timeCreatedLessThan: ${sqlFirewallPolicyTimeCreatedLessThan}
        violationAction: ${sqlFirewallPolicyViolationAction}
Copy

Using getSqlFirewallPolicies

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getSqlFirewallPolicies(args: GetSqlFirewallPoliciesArgs, opts?: InvokeOptions): Promise<GetSqlFirewallPoliciesResult>
function getSqlFirewallPoliciesOutput(args: GetSqlFirewallPoliciesOutputArgs, opts?: InvokeOptions): Output<GetSqlFirewallPoliciesResult>
Copy
def get_sql_firewall_policies(access_level: Optional[str] = None,
                              compartment_id: Optional[str] = None,
                              compartment_id_in_subtree: Optional[bool] = None,
                              db_user_name: Optional[str] = None,
                              display_name: Optional[str] = None,
                              filters: Optional[Sequence[_datasafe.GetSqlFirewallPoliciesFilter]] = None,
                              security_policy_id: Optional[str] = None,
                              sql_firewall_policy_id: Optional[str] = None,
                              state: Optional[str] = None,
                              time_created_greater_than_or_equal_to: Optional[str] = None,
                              time_created_less_than: Optional[str] = None,
                              violation_action: Optional[str] = None,
                              opts: Optional[InvokeOptions] = None) -> GetSqlFirewallPoliciesResult
def get_sql_firewall_policies_output(access_level: Optional[pulumi.Input[str]] = None,
                              compartment_id: Optional[pulumi.Input[str]] = None,
                              compartment_id_in_subtree: Optional[pulumi.Input[bool]] = None,
                              db_user_name: Optional[pulumi.Input[str]] = None,
                              display_name: Optional[pulumi.Input[str]] = None,
                              filters: Optional[pulumi.Input[Sequence[pulumi.Input[_datasafe.GetSqlFirewallPoliciesFilterArgs]]]] = None,
                              security_policy_id: Optional[pulumi.Input[str]] = None,
                              sql_firewall_policy_id: Optional[pulumi.Input[str]] = None,
                              state: Optional[pulumi.Input[str]] = None,
                              time_created_greater_than_or_equal_to: Optional[pulumi.Input[str]] = None,
                              time_created_less_than: Optional[pulumi.Input[str]] = None,
                              violation_action: Optional[pulumi.Input[str]] = None,
                              opts: Optional[InvokeOptions] = None) -> Output[GetSqlFirewallPoliciesResult]
Copy
func GetSqlFirewallPolicies(ctx *Context, args *GetSqlFirewallPoliciesArgs, opts ...InvokeOption) (*GetSqlFirewallPoliciesResult, error)
func GetSqlFirewallPoliciesOutput(ctx *Context, args *GetSqlFirewallPoliciesOutputArgs, opts ...InvokeOption) GetSqlFirewallPoliciesResultOutput
Copy

> Note: This function is named GetSqlFirewallPolicies in the Go SDK.

public static class GetSqlFirewallPolicies 
{
    public static Task<GetSqlFirewallPoliciesResult> InvokeAsync(GetSqlFirewallPoliciesArgs args, InvokeOptions? opts = null)
    public static Output<GetSqlFirewallPoliciesResult> Invoke(GetSqlFirewallPoliciesInvokeArgs args, InvokeOptions? opts = null)
}
Copy
public static CompletableFuture<GetSqlFirewallPoliciesResult> getSqlFirewallPolicies(GetSqlFirewallPoliciesArgs args, InvokeOptions options)
public static Output<GetSqlFirewallPoliciesResult> getSqlFirewallPolicies(GetSqlFirewallPoliciesArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: oci:DataSafe/getSqlFirewallPolicies:getSqlFirewallPolicies
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

CompartmentId This property is required. string
A filter to return only resources that match the specified compartment OCID.
AccessLevel string
Valid values are RESTRICTED and ACCESSIBLE. Default is RESTRICTED. Setting this to ACCESSIBLE returns only those compartments for which the user has INSPECT permissions directly or indirectly (permissions can be on a resource in a subcompartment). When set to RESTRICTED permissions are checked and no partial results are displayed.
CompartmentIdInSubtree bool
Default is false. When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned. Depends on the 'accessLevel' setting.
DbUserName string
A filter to return only items that match the specified user name.
DisplayName string
A filter to return only resources that match the specified display name.
Filters Changes to this property will trigger replacement. List<GetSqlFirewallPoliciesFilter>
SecurityPolicyId string
An optional filter to return only resources that match the specified OCID of the security policy resource.
SqlFirewallPolicyId string
An optional filter to return only resources that match the specified OCID of the SQL Firewall policy resource.
State string
The current state of the SQL Firewall policy.
TimeCreatedGreaterThanOrEqualTo string

A filter to return only the resources that were created after the specified date and time, as defined by RFC3339. Using TimeCreatedGreaterThanOrEqualToQueryParam parameter retrieves all resources created after that date.

Example: 2016-12-19T16:39:57.600Z

TimeCreatedLessThan string

Search for resources that were created before a specific date. Specifying this parameter corresponding timeCreatedLessThan parameter will retrieve all resources created before the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.

Example: 2016-12-19T16:39:57.600Z

ViolationAction string
An optional filter to return only resources that match the specified violation action.
CompartmentId This property is required. string
A filter to return only resources that match the specified compartment OCID.
AccessLevel string
Valid values are RESTRICTED and ACCESSIBLE. Default is RESTRICTED. Setting this to ACCESSIBLE returns only those compartments for which the user has INSPECT permissions directly or indirectly (permissions can be on a resource in a subcompartment). When set to RESTRICTED permissions are checked and no partial results are displayed.
CompartmentIdInSubtree bool
Default is false. When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned. Depends on the 'accessLevel' setting.
DbUserName string
A filter to return only items that match the specified user name.
DisplayName string
A filter to return only resources that match the specified display name.
Filters Changes to this property will trigger replacement. []GetSqlFirewallPoliciesFilter
SecurityPolicyId string
An optional filter to return only resources that match the specified OCID of the security policy resource.
SqlFirewallPolicyId string
An optional filter to return only resources that match the specified OCID of the SQL Firewall policy resource.
State string
The current state of the SQL Firewall policy.
TimeCreatedGreaterThanOrEqualTo string

A filter to return only the resources that were created after the specified date and time, as defined by RFC3339. Using TimeCreatedGreaterThanOrEqualToQueryParam parameter retrieves all resources created after that date.

Example: 2016-12-19T16:39:57.600Z

TimeCreatedLessThan string

Search for resources that were created before a specific date. Specifying this parameter corresponding timeCreatedLessThan parameter will retrieve all resources created before the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.

Example: 2016-12-19T16:39:57.600Z

ViolationAction string
An optional filter to return only resources that match the specified violation action.
compartmentId This property is required. String
A filter to return only resources that match the specified compartment OCID.
accessLevel String
Valid values are RESTRICTED and ACCESSIBLE. Default is RESTRICTED. Setting this to ACCESSIBLE returns only those compartments for which the user has INSPECT permissions directly or indirectly (permissions can be on a resource in a subcompartment). When set to RESTRICTED permissions are checked and no partial results are displayed.
compartmentIdInSubtree Boolean
Default is false. When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned. Depends on the 'accessLevel' setting.
dbUserName String
A filter to return only items that match the specified user name.
displayName String
A filter to return only resources that match the specified display name.
filters Changes to this property will trigger replacement. List<GetSqlFirewallPoliciesFilter>
securityPolicyId String
An optional filter to return only resources that match the specified OCID of the security policy resource.
sqlFirewallPolicyId String
An optional filter to return only resources that match the specified OCID of the SQL Firewall policy resource.
state String
The current state of the SQL Firewall policy.
timeCreatedGreaterThanOrEqualTo String

A filter to return only the resources that were created after the specified date and time, as defined by RFC3339. Using TimeCreatedGreaterThanOrEqualToQueryParam parameter retrieves all resources created after that date.

Example: 2016-12-19T16:39:57.600Z

timeCreatedLessThan String

Search for resources that were created before a specific date. Specifying this parameter corresponding timeCreatedLessThan parameter will retrieve all resources created before the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.

Example: 2016-12-19T16:39:57.600Z

violationAction String
An optional filter to return only resources that match the specified violation action.
compartmentId This property is required. string
A filter to return only resources that match the specified compartment OCID.
accessLevel string
Valid values are RESTRICTED and ACCESSIBLE. Default is RESTRICTED. Setting this to ACCESSIBLE returns only those compartments for which the user has INSPECT permissions directly or indirectly (permissions can be on a resource in a subcompartment). When set to RESTRICTED permissions are checked and no partial results are displayed.
compartmentIdInSubtree boolean
Default is false. When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned. Depends on the 'accessLevel' setting.
dbUserName string
A filter to return only items that match the specified user name.
displayName string
A filter to return only resources that match the specified display name.
filters Changes to this property will trigger replacement. GetSqlFirewallPoliciesFilter[]
securityPolicyId string
An optional filter to return only resources that match the specified OCID of the security policy resource.
sqlFirewallPolicyId string
An optional filter to return only resources that match the specified OCID of the SQL Firewall policy resource.
state string
The current state of the SQL Firewall policy.
timeCreatedGreaterThanOrEqualTo string

A filter to return only the resources that were created after the specified date and time, as defined by RFC3339. Using TimeCreatedGreaterThanOrEqualToQueryParam parameter retrieves all resources created after that date.

Example: 2016-12-19T16:39:57.600Z

timeCreatedLessThan string

Search for resources that were created before a specific date. Specifying this parameter corresponding timeCreatedLessThan parameter will retrieve all resources created before the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.

Example: 2016-12-19T16:39:57.600Z

violationAction string
An optional filter to return only resources that match the specified violation action.
compartment_id This property is required. str
A filter to return only resources that match the specified compartment OCID.
access_level str
Valid values are RESTRICTED and ACCESSIBLE. Default is RESTRICTED. Setting this to ACCESSIBLE returns only those compartments for which the user has INSPECT permissions directly or indirectly (permissions can be on a resource in a subcompartment). When set to RESTRICTED permissions are checked and no partial results are displayed.
compartment_id_in_subtree bool
Default is false. When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned. Depends on the 'accessLevel' setting.
db_user_name str
A filter to return only items that match the specified user name.
display_name str
A filter to return only resources that match the specified display name.
filters Changes to this property will trigger replacement. Sequence[datasafe.GetSqlFirewallPoliciesFilter]
security_policy_id str
An optional filter to return only resources that match the specified OCID of the security policy resource.
sql_firewall_policy_id str
An optional filter to return only resources that match the specified OCID of the SQL Firewall policy resource.
state str
The current state of the SQL Firewall policy.
time_created_greater_than_or_equal_to str

A filter to return only the resources that were created after the specified date and time, as defined by RFC3339. Using TimeCreatedGreaterThanOrEqualToQueryParam parameter retrieves all resources created after that date.

Example: 2016-12-19T16:39:57.600Z

time_created_less_than str

Search for resources that were created before a specific date. Specifying this parameter corresponding timeCreatedLessThan parameter will retrieve all resources created before the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.

Example: 2016-12-19T16:39:57.600Z

violation_action str
An optional filter to return only resources that match the specified violation action.
compartmentId This property is required. String
A filter to return only resources that match the specified compartment OCID.
accessLevel String
Valid values are RESTRICTED and ACCESSIBLE. Default is RESTRICTED. Setting this to ACCESSIBLE returns only those compartments for which the user has INSPECT permissions directly or indirectly (permissions can be on a resource in a subcompartment). When set to RESTRICTED permissions are checked and no partial results are displayed.
compartmentIdInSubtree Boolean
Default is false. When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned. Depends on the 'accessLevel' setting.
dbUserName String
A filter to return only items that match the specified user name.
displayName String
A filter to return only resources that match the specified display name.
filters Changes to this property will trigger replacement. List<Property Map>
securityPolicyId String
An optional filter to return only resources that match the specified OCID of the security policy resource.
sqlFirewallPolicyId String
An optional filter to return only resources that match the specified OCID of the SQL Firewall policy resource.
state String
The current state of the SQL Firewall policy.
timeCreatedGreaterThanOrEqualTo String

A filter to return only the resources that were created after the specified date and time, as defined by RFC3339. Using TimeCreatedGreaterThanOrEqualToQueryParam parameter retrieves all resources created after that date.

Example: 2016-12-19T16:39:57.600Z

timeCreatedLessThan String

Search for resources that were created before a specific date. Specifying this parameter corresponding timeCreatedLessThan parameter will retrieve all resources created before the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.

Example: 2016-12-19T16:39:57.600Z

violationAction String
An optional filter to return only resources that match the specified violation action.

getSqlFirewallPolicies Result

The following output properties are available:

CompartmentId string
The OCID of the compartment containing the SQL Firewall policy.
Id string
The provider-assigned unique ID for this managed resource.
SqlFirewallPolicyCollections List<GetSqlFirewallPoliciesSqlFirewallPolicyCollection>
The list of sql_firewall_policy_collection.
AccessLevel string
CompartmentIdInSubtree bool
DbUserName string
The database user name.
DisplayName string
The display name of the SQL Firewall policy.
Filters List<GetSqlFirewallPoliciesFilter>
SecurityPolicyId string
The OCID of the security policy corresponding to the SQL Firewall policy.
SqlFirewallPolicyId string
State string
The current state of the SQL Firewall policy.
TimeCreatedGreaterThanOrEqualTo string
TimeCreatedLessThan string
ViolationAction string
Specifies the mode in which the SQL Firewall policy is enabled.
CompartmentId string
The OCID of the compartment containing the SQL Firewall policy.
Id string
The provider-assigned unique ID for this managed resource.
SqlFirewallPolicyCollections []GetSqlFirewallPoliciesSqlFirewallPolicyCollection
The list of sql_firewall_policy_collection.
AccessLevel string
CompartmentIdInSubtree bool
DbUserName string
The database user name.
DisplayName string
The display name of the SQL Firewall policy.
Filters []GetSqlFirewallPoliciesFilter
SecurityPolicyId string
The OCID of the security policy corresponding to the SQL Firewall policy.
SqlFirewallPolicyId string
State string
The current state of the SQL Firewall policy.
TimeCreatedGreaterThanOrEqualTo string
TimeCreatedLessThan string
ViolationAction string
Specifies the mode in which the SQL Firewall policy is enabled.
compartmentId String
The OCID of the compartment containing the SQL Firewall policy.
id String
The provider-assigned unique ID for this managed resource.
sqlFirewallPolicyCollections List<GetSqlFirewallPoliciesSqlFirewallPolicyCollection>
The list of sql_firewall_policy_collection.
accessLevel String
compartmentIdInSubtree Boolean
dbUserName String
The database user name.
displayName String
The display name of the SQL Firewall policy.
filters List<GetSqlFirewallPoliciesFilter>
securityPolicyId String
The OCID of the security policy corresponding to the SQL Firewall policy.
sqlFirewallPolicyId String
state String
The current state of the SQL Firewall policy.
timeCreatedGreaterThanOrEqualTo String
timeCreatedLessThan String
violationAction String
Specifies the mode in which the SQL Firewall policy is enabled.
compartmentId string
The OCID of the compartment containing the SQL Firewall policy.
id string
The provider-assigned unique ID for this managed resource.
sqlFirewallPolicyCollections GetSqlFirewallPoliciesSqlFirewallPolicyCollection[]
The list of sql_firewall_policy_collection.
accessLevel string
compartmentIdInSubtree boolean
dbUserName string
The database user name.
displayName string
The display name of the SQL Firewall policy.
filters GetSqlFirewallPoliciesFilter[]
securityPolicyId string
The OCID of the security policy corresponding to the SQL Firewall policy.
sqlFirewallPolicyId string
state string
The current state of the SQL Firewall policy.
timeCreatedGreaterThanOrEqualTo string
timeCreatedLessThan string
violationAction string
Specifies the mode in which the SQL Firewall policy is enabled.
compartment_id str
The OCID of the compartment containing the SQL Firewall policy.
id str
The provider-assigned unique ID for this managed resource.
sql_firewall_policy_collections Sequence[datasafe.GetSqlFirewallPoliciesSqlFirewallPolicyCollection]
The list of sql_firewall_policy_collection.
access_level str
compartment_id_in_subtree bool
db_user_name str
The database user name.
display_name str
The display name of the SQL Firewall policy.
filters Sequence[datasafe.GetSqlFirewallPoliciesFilter]
security_policy_id str
The OCID of the security policy corresponding to the SQL Firewall policy.
sql_firewall_policy_id str
state str
The current state of the SQL Firewall policy.
time_created_greater_than_or_equal_to str
time_created_less_than str
violation_action str
Specifies the mode in which the SQL Firewall policy is enabled.
compartmentId String
The OCID of the compartment containing the SQL Firewall policy.
id String
The provider-assigned unique ID for this managed resource.
sqlFirewallPolicyCollections List<Property Map>
The list of sql_firewall_policy_collection.
accessLevel String
compartmentIdInSubtree Boolean
dbUserName String
The database user name.
displayName String
The display name of the SQL Firewall policy.
filters List<Property Map>
securityPolicyId String
The OCID of the security policy corresponding to the SQL Firewall policy.
sqlFirewallPolicyId String
state String
The current state of the SQL Firewall policy.
timeCreatedGreaterThanOrEqualTo String
timeCreatedLessThan String
violationAction String
Specifies the mode in which the SQL Firewall policy is enabled.

Supporting Types

GetSqlFirewallPoliciesFilter

Name This property is required. string
Values This property is required. List<string>
Regex bool
Name This property is required. string
Values This property is required. []string
Regex bool
name This property is required. String
values This property is required. List<String>
regex Boolean
name This property is required. string
values This property is required. string[]
regex boolean
name This property is required. str
values This property is required. Sequence[str]
regex bool
name This property is required. String
values This property is required. List<String>
regex Boolean

GetSqlFirewallPoliciesSqlFirewallPolicyCollection

items This property is required. List<Property Map>

GetSqlFirewallPoliciesSqlFirewallPolicyCollectionItem

AllowedClientIps This property is required. List<string>
The list of allowed ip addresses for the SQL Firewall policy.
AllowedClientOsUsernames This property is required. List<string>
The list of allowed operating system user names for the SQL Firewall policy.
AllowedClientPrograms This property is required. List<string>
The list of allowed client programs for the SQL Firewall policy.
CompartmentId This property is required. string
A filter to return only resources that match the specified compartment OCID.
DbUserName This property is required. string
A filter to return only items that match the specified user name.
DefinedTags This property is required. Dictionary<string, string>
Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags Example: {"Operations.CostCenter": "42"}
Description This property is required. string
The description of the SQL Firewall policy.
DisplayName This property is required. string
A filter to return only resources that match the specified display name.
EnforcementScope This property is required. string
Specifies the SQL Firewall policy enforcement option.
FreeformTags This property is required. Dictionary<string, string>
Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags Example: {"Department": "Finance"}
Id This property is required. string
The OCID of the SQL Firewall policy.
LifecycleDetails This property is required. string
Details about the current state of the SQL Firewall policy in Data Safe.
SecurityPolicyId This property is required. string
An optional filter to return only resources that match the specified OCID of the security policy resource.
SqlFirewallPolicyId This property is required. string
An optional filter to return only resources that match the specified OCID of the SQL Firewall policy resource.
SqlLevel This property is required. string
Specifies the level of SQL included for this SQL Firewall policy. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
State This property is required. string
The current state of the SQL Firewall policy.
Status This property is required. string
Specifies whether the SQL Firewall policy is enabled or disabled.
SystemTags This property is required. Dictionary<string, string>
System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"orcl-cloud.free-tier-retained": "true"}
TimeCreated This property is required. string
The time that the SQL Firewall policy was created, in the format defined by RFC3339.
TimeUpdated This property is required. string
The date and time the SQL Firewall policy was last updated, in the format defined by RFC3339.
ViolationAction This property is required. string
An optional filter to return only resources that match the specified violation action.
ViolationAudit This property is required. string
Specifies whether a unified audit policy should be enabled for auditing the SQL Firewall policy violations.
AllowedClientIps This property is required. []string
The list of allowed ip addresses for the SQL Firewall policy.
AllowedClientOsUsernames This property is required. []string
The list of allowed operating system user names for the SQL Firewall policy.
AllowedClientPrograms This property is required. []string
The list of allowed client programs for the SQL Firewall policy.
CompartmentId This property is required. string
A filter to return only resources that match the specified compartment OCID.
DbUserName This property is required. string
A filter to return only items that match the specified user name.
DefinedTags This property is required. map[string]string
Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags Example: {"Operations.CostCenter": "42"}
Description This property is required. string
The description of the SQL Firewall policy.
DisplayName This property is required. string
A filter to return only resources that match the specified display name.
EnforcementScope This property is required. string
Specifies the SQL Firewall policy enforcement option.
FreeformTags This property is required. map[string]string
Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags Example: {"Department": "Finance"}
Id This property is required. string
The OCID of the SQL Firewall policy.
LifecycleDetails This property is required. string
Details about the current state of the SQL Firewall policy in Data Safe.
SecurityPolicyId This property is required. string
An optional filter to return only resources that match the specified OCID of the security policy resource.
SqlFirewallPolicyId This property is required. string
An optional filter to return only resources that match the specified OCID of the SQL Firewall policy resource.
SqlLevel This property is required. string
Specifies the level of SQL included for this SQL Firewall policy. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
State This property is required. string
The current state of the SQL Firewall policy.
Status This property is required. string
Specifies whether the SQL Firewall policy is enabled or disabled.
SystemTags This property is required. map[string]string
System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"orcl-cloud.free-tier-retained": "true"}
TimeCreated This property is required. string
The time that the SQL Firewall policy was created, in the format defined by RFC3339.
TimeUpdated This property is required. string
The date and time the SQL Firewall policy was last updated, in the format defined by RFC3339.
ViolationAction This property is required. string
An optional filter to return only resources that match the specified violation action.
ViolationAudit This property is required. string
Specifies whether a unified audit policy should be enabled for auditing the SQL Firewall policy violations.
allowedClientIps This property is required. List<String>
The list of allowed ip addresses for the SQL Firewall policy.
allowedClientOsUsernames This property is required. List<String>
The list of allowed operating system user names for the SQL Firewall policy.
allowedClientPrograms This property is required. List<String>
The list of allowed client programs for the SQL Firewall policy.
compartmentId This property is required. String
A filter to return only resources that match the specified compartment OCID.
dbUserName This property is required. String
A filter to return only items that match the specified user name.
definedTags This property is required. Map<String,String>
Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags Example: {"Operations.CostCenter": "42"}
description This property is required. String
The description of the SQL Firewall policy.
displayName This property is required. String
A filter to return only resources that match the specified display name.
enforcementScope This property is required. String
Specifies the SQL Firewall policy enforcement option.
freeformTags This property is required. Map<String,String>
Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags Example: {"Department": "Finance"}
id This property is required. String
The OCID of the SQL Firewall policy.
lifecycleDetails This property is required. String
Details about the current state of the SQL Firewall policy in Data Safe.
securityPolicyId This property is required. String
An optional filter to return only resources that match the specified OCID of the security policy resource.
sqlFirewallPolicyId This property is required. String
An optional filter to return only resources that match the specified OCID of the SQL Firewall policy resource.
sqlLevel This property is required. String
Specifies the level of SQL included for this SQL Firewall policy. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
state This property is required. String
The current state of the SQL Firewall policy.
status This property is required. String
Specifies whether the SQL Firewall policy is enabled or disabled.
systemTags This property is required. Map<String,String>
System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"orcl-cloud.free-tier-retained": "true"}
timeCreated This property is required. String
The time that the SQL Firewall policy was created, in the format defined by RFC3339.
timeUpdated This property is required. String
The date and time the SQL Firewall policy was last updated, in the format defined by RFC3339.
violationAction This property is required. String
An optional filter to return only resources that match the specified violation action.
violationAudit This property is required. String
Specifies whether a unified audit policy should be enabled for auditing the SQL Firewall policy violations.
allowedClientIps This property is required. string[]
The list of allowed ip addresses for the SQL Firewall policy.
allowedClientOsUsernames This property is required. string[]
The list of allowed operating system user names for the SQL Firewall policy.
allowedClientPrograms This property is required. string[]
The list of allowed client programs for the SQL Firewall policy.
compartmentId This property is required. string
A filter to return only resources that match the specified compartment OCID.
dbUserName This property is required. string
A filter to return only items that match the specified user name.
definedTags This property is required. {[key: string]: string}
Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags Example: {"Operations.CostCenter": "42"}
description This property is required. string
The description of the SQL Firewall policy.
displayName This property is required. string
A filter to return only resources that match the specified display name.
enforcementScope This property is required. string
Specifies the SQL Firewall policy enforcement option.
freeformTags This property is required. {[key: string]: string}
Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags Example: {"Department": "Finance"}
id This property is required. string
The OCID of the SQL Firewall policy.
lifecycleDetails This property is required. string
Details about the current state of the SQL Firewall policy in Data Safe.
securityPolicyId This property is required. string
An optional filter to return only resources that match the specified OCID of the security policy resource.
sqlFirewallPolicyId This property is required. string
An optional filter to return only resources that match the specified OCID of the SQL Firewall policy resource.
sqlLevel This property is required. string
Specifies the level of SQL included for this SQL Firewall policy. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
state This property is required. string
The current state of the SQL Firewall policy.
status This property is required. string
Specifies whether the SQL Firewall policy is enabled or disabled.
systemTags This property is required. {[key: string]: string}
System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"orcl-cloud.free-tier-retained": "true"}
timeCreated This property is required. string
The time that the SQL Firewall policy was created, in the format defined by RFC3339.
timeUpdated This property is required. string
The date and time the SQL Firewall policy was last updated, in the format defined by RFC3339.
violationAction This property is required. string
An optional filter to return only resources that match the specified violation action.
violationAudit This property is required. string
Specifies whether a unified audit policy should be enabled for auditing the SQL Firewall policy violations.
allowed_client_ips This property is required. Sequence[str]
The list of allowed ip addresses for the SQL Firewall policy.
allowed_client_os_usernames This property is required. Sequence[str]
The list of allowed operating system user names for the SQL Firewall policy.
allowed_client_programs This property is required. Sequence[str]
The list of allowed client programs for the SQL Firewall policy.
compartment_id This property is required. str
A filter to return only resources that match the specified compartment OCID.
db_user_name This property is required. str
A filter to return only items that match the specified user name.
defined_tags This property is required. Mapping[str, str]
Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags Example: {"Operations.CostCenter": "42"}
description This property is required. str
The description of the SQL Firewall policy.
display_name This property is required. str
A filter to return only resources that match the specified display name.
enforcement_scope This property is required. str
Specifies the SQL Firewall policy enforcement option.
freeform_tags This property is required. Mapping[str, str]
Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags Example: {"Department": "Finance"}
id This property is required. str
The OCID of the SQL Firewall policy.
lifecycle_details This property is required. str
Details about the current state of the SQL Firewall policy in Data Safe.
security_policy_id This property is required. str
An optional filter to return only resources that match the specified OCID of the security policy resource.
sql_firewall_policy_id This property is required. str
An optional filter to return only resources that match the specified OCID of the SQL Firewall policy resource.
sql_level This property is required. str
Specifies the level of SQL included for this SQL Firewall policy. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
state This property is required. str
The current state of the SQL Firewall policy.
status This property is required. str
Specifies whether the SQL Firewall policy is enabled or disabled.
system_tags This property is required. Mapping[str, str]
System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"orcl-cloud.free-tier-retained": "true"}
time_created This property is required. str
The time that the SQL Firewall policy was created, in the format defined by RFC3339.
time_updated This property is required. str
The date and time the SQL Firewall policy was last updated, in the format defined by RFC3339.
violation_action This property is required. str
An optional filter to return only resources that match the specified violation action.
violation_audit This property is required. str
Specifies whether a unified audit policy should be enabled for auditing the SQL Firewall policy violations.
allowedClientIps This property is required. List<String>
The list of allowed ip addresses for the SQL Firewall policy.
allowedClientOsUsernames This property is required. List<String>
The list of allowed operating system user names for the SQL Firewall policy.
allowedClientPrograms This property is required. List<String>
The list of allowed client programs for the SQL Firewall policy.
compartmentId This property is required. String
A filter to return only resources that match the specified compartment OCID.
dbUserName This property is required. String
A filter to return only items that match the specified user name.
definedTags This property is required. Map<String>
Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags Example: {"Operations.CostCenter": "42"}
description This property is required. String
The description of the SQL Firewall policy.
displayName This property is required. String
A filter to return only resources that match the specified display name.
enforcementScope This property is required. String
Specifies the SQL Firewall policy enforcement option.
freeformTags This property is required. Map<String>
Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags Example: {"Department": "Finance"}
id This property is required. String
The OCID of the SQL Firewall policy.
lifecycleDetails This property is required. String
Details about the current state of the SQL Firewall policy in Data Safe.
securityPolicyId This property is required. String
An optional filter to return only resources that match the specified OCID of the security policy resource.
sqlFirewallPolicyId This property is required. String
An optional filter to return only resources that match the specified OCID of the SQL Firewall policy resource.
sqlLevel This property is required. String
Specifies the level of SQL included for this SQL Firewall policy. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
state This property is required. String
The current state of the SQL Firewall policy.
status This property is required. String
Specifies whether the SQL Firewall policy is enabled or disabled.
systemTags This property is required. Map<String>
System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"orcl-cloud.free-tier-retained": "true"}
timeCreated This property is required. String
The time that the SQL Firewall policy was created, in the format defined by RFC3339.
timeUpdated This property is required. String
The date and time the SQL Firewall policy was last updated, in the format defined by RFC3339.
violationAction This property is required. String
An optional filter to return only resources that match the specified violation action.
violationAudit This property is required. String
Specifies whether a unified audit policy should be enabled for auditing the SQL Firewall policy violations.

Package Details

Repository
oci pulumi/pulumi-oci
License
Apache-2.0
Notes
This Pulumi package is based on the oci Terraform Provider.
Oracle Cloud Infrastructure v2.30.0 published on Monday, Apr 14, 2025 by Pulumi