Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DataSafe
  5. getSqlFirewallPolicy
Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
pulumi/pulumi-oci

oci.DataSafe.getSqlFirewallPolicy

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
pulumi/pulumi-oci

    This data source provides details about a specific Sql Firewall Policy resource in Oracle Cloud Infrastructure Data Safe service.

    Gets a SQL Firewall policy by identifier.

    Example Usage

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

const testSqlFirewallPolicy = oci.DataSafe.getSqlFirewallPolicy({
    sqlFirewallPolicyId: testSqlFirewallPolicyOciDataSafeSqlFirewallPolicy.id,
});

    import pulumi
import pulumi_oci as oci

test_sql_firewall_policy = oci.DataSafe.get_sql_firewall_policy(sql_firewall_policy_id=test_sql_firewall_policy_oci_data_safe_sql_firewall_policy["id"])

    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.GetSqlFirewallPolicy(ctx, &datasafe.GetSqlFirewallPolicyArgs{
			SqlFirewallPolicyId: testSqlFirewallPolicyOciDataSafeSqlFirewallPolicy.Id,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testSqlFirewallPolicy = Oci.DataSafe.GetSqlFirewallPolicy.Invoke(new()
    {
        SqlFirewallPolicyId = testSqlFirewallPolicyOciDataSafeSqlFirewallPolicy.Id,
    });

});

    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.GetSqlFirewallPolicyArgs;
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 testSqlFirewallPolicy = DataSafeFunctions.getSqlFirewallPolicy(GetSqlFirewallPolicyArgs.builder()
            .sqlFirewallPolicyId(testSqlFirewallPolicyOciDataSafeSqlFirewallPolicy.id())
            .build());

    }
}

    variables:
  testSqlFirewallPolicy:
    fn::invoke:
      function: oci:DataSafe:getSqlFirewallPolicy
      arguments:
        sqlFirewallPolicyId: ${testSqlFirewallPolicyOciDataSafeSqlFirewallPolicy.id}

    Using getSqlFirewallPolicy

    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 getSqlFirewallPolicy(args: GetSqlFirewallPolicyArgs, opts?: InvokeOptions): Promise<GetSqlFirewallPolicyResult>
function getSqlFirewallPolicyOutput(args: GetSqlFirewallPolicyOutputArgs, opts?: InvokeOptions): Output<GetSqlFirewallPolicyResult>
    def get_sql_firewall_policy(sql_firewall_policy_id: Optional[str] = None,
                            opts: Optional[InvokeOptions] = None) -> GetSqlFirewallPolicyResult
def get_sql_firewall_policy_output(sql_firewall_policy_id: Optional[pulumi.Input[str]] = None,
                            opts: Optional[InvokeOptions] = None) -> Output[GetSqlFirewallPolicyResult]
    func LookupSqlFirewallPolicy(ctx *Context, args *LookupSqlFirewallPolicyArgs, opts ...InvokeOption) (*LookupSqlFirewallPolicyResult, error)
func LookupSqlFirewallPolicyOutput(ctx *Context, args *LookupSqlFirewallPolicyOutputArgs, opts ...InvokeOption) LookupSqlFirewallPolicyResultOutput

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

    public static class GetSqlFirewallPolicy 
{
    public static Task<GetSqlFirewallPolicyResult> InvokeAsync(GetSqlFirewallPolicyArgs args, InvokeOptions? opts = null)
    public static Output<GetSqlFirewallPolicyResult> Invoke(GetSqlFirewallPolicyInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetSqlFirewallPolicyResult> getSqlFirewallPolicy(GetSqlFirewallPolicyArgs args, InvokeOptions options)
public static Output<GetSqlFirewallPolicyResult> getSqlFirewallPolicy(GetSqlFirewallPolicyArgs args, InvokeOptions options)

    fn::invoke:
  function: oci:DataSafe/getSqlFirewallPolicy:getSqlFirewallPolicy
  arguments:
    # arguments dictionary

    The following arguments are supported:

    SqlFirewallPolicyId string
    The OCID of the SQL Firewall policy resource.
    SqlFirewallPolicyId string
    The OCID of the SQL Firewall policy resource.
    sqlFirewallPolicyId String
    The OCID of the SQL Firewall policy resource.
    sqlFirewallPolicyId string
    The OCID of the SQL Firewall policy resource.
    sql_firewall_policy_id str
    The OCID of the SQL Firewall policy resource.
    sqlFirewallPolicyId String
    The OCID of the SQL Firewall policy resource.

    getSqlFirewallPolicy Result

    The following output properties are available:

    AllowedClientIps List<string>
    The list of allowed ip addresses for the SQL Firewall policy.
    AllowedClientOsUsernames List<string>
    The list of allowed operating system user names for the SQL Firewall policy.
    AllowedClientPrograms List<string>
    The list of allowed client programs for the SQL Firewall policy.
    CompartmentId string
    The OCID of the compartment containing the SQL Firewall policy.
    DbUserName string
    The database user name.
    DefinedTags 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 string
    The description of the SQL Firewall policy.
    DisplayName string
    The display name of the SQL Firewall policy.
    EnforcementScope string
    Specifies the SQL Firewall policy enforcement option.
    FreeformTags 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 string
    The OCID of the SQL Firewall policy.
    LifecycleDetails string
    Details about the current state of the SQL Firewall policy in Data Safe.
    SecurityPolicyId string
    The OCID of the security policy corresponding to the SQL Firewall policy.
    SqlFirewallPolicyId string
    SqlLevel 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 string
    The current state of the SQL Firewall policy.
    Status string
    Specifies whether the SQL Firewall policy is enabled or disabled.
    SystemTags 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 string
    The time that the SQL Firewall policy was created, in the format defined by RFC3339.
    TimeUpdated string
    The date and time the SQL Firewall policy was last updated, in the format defined by RFC3339.
    ViolationAction string
    Specifies the mode in which the SQL Firewall policy is enabled.
    ViolationAudit string
    Specifies whether a unified audit policy should be enabled for auditing the SQL Firewall policy violations.
    AllowedClientIps []string
    The list of allowed ip addresses for the SQL Firewall policy.
    AllowedClientOsUsernames []string
    The list of allowed operating system user names for the SQL Firewall policy.
    AllowedClientPrograms []string
    The list of allowed client programs for the SQL Firewall policy.
    CompartmentId string
    The OCID of the compartment containing the SQL Firewall policy.
    DbUserName string
    The database user name.
    DefinedTags 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 string
    The description of the SQL Firewall policy.
    DisplayName string
    The display name of the SQL Firewall policy.
    EnforcementScope string
    Specifies the SQL Firewall policy enforcement option.
    FreeformTags 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 string
    The OCID of the SQL Firewall policy.
    LifecycleDetails string
    Details about the current state of the SQL Firewall policy in Data Safe.
    SecurityPolicyId string
    The OCID of the security policy corresponding to the SQL Firewall policy.
    SqlFirewallPolicyId string
    SqlLevel 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 string
    The current state of the SQL Firewall policy.
    Status string
    Specifies whether the SQL Firewall policy is enabled or disabled.
    SystemTags 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 string
    The time that the SQL Firewall policy was created, in the format defined by RFC3339.
    TimeUpdated string
    The date and time the SQL Firewall policy was last updated, in the format defined by RFC3339.
    ViolationAction string
    Specifies the mode in which the SQL Firewall policy is enabled.
    ViolationAudit string
    Specifies whether a unified audit policy should be enabled for auditing the SQL Firewall policy violations.
    allowedClientIps List<String>
    The list of allowed ip addresses for the SQL Firewall policy.
    allowedClientOsUsernames List<String>
    The list of allowed operating system user names for the SQL Firewall policy.
    allowedClientPrograms List<String>
    The list of allowed client programs for the SQL Firewall policy.
    compartmentId String
    The OCID of the compartment containing the SQL Firewall policy.
    dbUserName String
    The database user name.
    definedTags 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 String
    The description of the SQL Firewall policy.
    displayName String
    The display name of the SQL Firewall policy.
    enforcementScope String
    Specifies the SQL Firewall policy enforcement option.
    freeformTags 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 String
    The OCID of the SQL Firewall policy.
    lifecycleDetails String
    Details about the current state of the SQL Firewall policy in Data Safe.
    securityPolicyId String
    The OCID of the security policy corresponding to the SQL Firewall policy.
    sqlFirewallPolicyId String
    sqlLevel 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 String
    The current state of the SQL Firewall policy.
    status String
    Specifies whether the SQL Firewall policy is enabled or disabled.
    systemTags 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 String
    The time that the SQL Firewall policy was created, in the format defined by RFC3339.
    timeUpdated String
    The date and time the SQL Firewall policy was last updated, in the format defined by RFC3339.
    violationAction String
    Specifies the mode in which the SQL Firewall policy is enabled.
    violationAudit String
    Specifies whether a unified audit policy should be enabled for auditing the SQL Firewall policy violations.
    allowedClientIps string[]
    The list of allowed ip addresses for the SQL Firewall policy.
    allowedClientOsUsernames string[]
    The list of allowed operating system user names for the SQL Firewall policy.
    allowedClientPrograms string[]
    The list of allowed client programs for the SQL Firewall policy.
    compartmentId string
    The OCID of the compartment containing the SQL Firewall policy.
    dbUserName string
    The database user name.
    definedTags {[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 string
    The description of the SQL Firewall policy.
    displayName string
    The display name of the SQL Firewall policy.
    enforcementScope string
    Specifies the SQL Firewall policy enforcement option.
    freeformTags {[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 string
    The OCID of the SQL Firewall policy.
    lifecycleDetails string
    Details about the current state of the SQL Firewall policy in Data Safe.
    securityPolicyId string
    The OCID of the security policy corresponding to the SQL Firewall policy.
    sqlFirewallPolicyId string
    sqlLevel 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 string
    The current state of the SQL Firewall policy.
    status string
    Specifies whether the SQL Firewall policy is enabled or disabled.
    systemTags {[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 string
    The time that the SQL Firewall policy was created, in the format defined by RFC3339.
    timeUpdated string
    The date and time the SQL Firewall policy was last updated, in the format defined by RFC3339.
    violationAction string
    Specifies the mode in which the SQL Firewall policy is enabled.
    violationAudit string
    Specifies whether a unified audit policy should be enabled for auditing the SQL Firewall policy violations.
    allowed_client_ips Sequence[str]
    The list of allowed ip addresses for the SQL Firewall policy.
    allowed_client_os_usernames Sequence[str]
    The list of allowed operating system user names for the SQL Firewall policy.
    allowed_client_programs Sequence[str]
    The list of allowed client programs for the SQL Firewall policy.
    compartment_id str
    The OCID of the compartment containing the SQL Firewall policy.
    db_user_name str
    The database user name.
    defined_tags 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 str
    The description of the SQL Firewall policy.
    display_name str
    The display name of the SQL Firewall policy.
    enforcement_scope str
    Specifies the SQL Firewall policy enforcement option.
    freeform_tags 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 str
    The OCID of the SQL Firewall policy.
    lifecycle_details str
    Details about the current state of the SQL Firewall policy in Data Safe.
    security_policy_id str
    The OCID of the security policy corresponding to the SQL Firewall policy.
    sql_firewall_policy_id str
    sql_level 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 str
    The current state of the SQL Firewall policy.
    status str
    Specifies whether the SQL Firewall policy is enabled or disabled.
    system_tags 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 str
    The time that the SQL Firewall policy was created, in the format defined by RFC3339.
    time_updated str
    The date and time the SQL Firewall policy was last updated, in the format defined by RFC3339.
    violation_action str
    Specifies the mode in which the SQL Firewall policy is enabled.
    violation_audit str
    Specifies whether a unified audit policy should be enabled for auditing the SQL Firewall policy violations.
    allowedClientIps List<String>
    The list of allowed ip addresses for the SQL Firewall policy.
    allowedClientOsUsernames List<String>
    The list of allowed operating system user names for the SQL Firewall policy.
    allowedClientPrograms List<String>
    The list of allowed client programs for the SQL Firewall policy.
    compartmentId String
    The OCID of the compartment containing the SQL Firewall policy.
    dbUserName String
    The database user name.
    definedTags 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 String
    The description of the SQL Firewall policy.
    displayName String
    The display name of the SQL Firewall policy.
    enforcementScope String
    Specifies the SQL Firewall policy enforcement option.
    freeformTags 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 String
    The OCID of the SQL Firewall policy.
    lifecycleDetails String
    Details about the current state of the SQL Firewall policy in Data Safe.
    securityPolicyId String
    The OCID of the security policy corresponding to the SQL Firewall policy.
    sqlFirewallPolicyId String
    sqlLevel 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 String
    The current state of the SQL Firewall policy.
    status String
    Specifies whether the SQL Firewall policy is enabled or disabled.
    systemTags 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 String
    The time that the SQL Firewall policy was created, in the format defined by RFC3339.
    timeUpdated String
    The date and time the SQL Firewall policy was last updated, in the format defined by RFC3339.
    violationAction String
    Specifies the mode in which the SQL Firewall policy is enabled.
    violationAudit 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.
    oci logo
    Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
    pulumi/pulumi-oci