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

oci.DataSafe.getSqlFirewallAllowedSql

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi
pulumi/pulumi-oci

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

    Gets a SQL firewall allowed SQL by identifier.

    Example Usage

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

const testSqlFirewallAllowedSql = oci.DataSafe.getSqlFirewallAllowedSql({
    sqlFirewallAllowedSqlId: testSqlFirewallAllowedSqlOciDataSafeSqlFirewallAllowedSql.id,
});

    import pulumi
import pulumi_oci as oci

test_sql_firewall_allowed_sql = oci.DataSafe.get_sql_firewall_allowed_sql(sql_firewall_allowed_sql_id=test_sql_firewall_allowed_sql_oci_data_safe_sql_firewall_allowed_sql["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.GetSqlFirewallAllowedSql(ctx, &datasafe.GetSqlFirewallAllowedSqlArgs{
			SqlFirewallAllowedSqlId: testSqlFirewallAllowedSqlOciDataSafeSqlFirewallAllowedSql.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 testSqlFirewallAllowedSql = Oci.DataSafe.GetSqlFirewallAllowedSql.Invoke(new()
    {
        SqlFirewallAllowedSqlId = testSqlFirewallAllowedSqlOciDataSafeSqlFirewallAllowedSql.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.GetSqlFirewallAllowedSqlArgs;
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 testSqlFirewallAllowedSql = DataSafeFunctions.getSqlFirewallAllowedSql(GetSqlFirewallAllowedSqlArgs.builder()
            .sqlFirewallAllowedSqlId(testSqlFirewallAllowedSqlOciDataSafeSqlFirewallAllowedSql.id())
            .build());

    }
}

    variables:
  testSqlFirewallAllowedSql:
    fn::invoke:
      function: oci:DataSafe:getSqlFirewallAllowedSql
      arguments:
        sqlFirewallAllowedSqlId: ${testSqlFirewallAllowedSqlOciDataSafeSqlFirewallAllowedSql.id}

    Using getSqlFirewallAllowedSql

    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 getSqlFirewallAllowedSql(args: GetSqlFirewallAllowedSqlArgs, opts?: InvokeOptions): Promise<GetSqlFirewallAllowedSqlResult>
function getSqlFirewallAllowedSqlOutput(args: GetSqlFirewallAllowedSqlOutputArgs, opts?: InvokeOptions): Output<GetSqlFirewallAllowedSqlResult>
    def get_sql_firewall_allowed_sql(sql_firewall_allowed_sql_id: Optional[str] = None,
                                 opts: Optional[InvokeOptions] = None) -> GetSqlFirewallAllowedSqlResult
def get_sql_firewall_allowed_sql_output(sql_firewall_allowed_sql_id: Optional[pulumi.Input[str]] = None,
                                 opts: Optional[InvokeOptions] = None) -> Output[GetSqlFirewallAllowedSqlResult]
    func GetSqlFirewallAllowedSql(ctx *Context, args *GetSqlFirewallAllowedSqlArgs, opts ...InvokeOption) (*GetSqlFirewallAllowedSqlResult, error)
func GetSqlFirewallAllowedSqlOutput(ctx *Context, args *GetSqlFirewallAllowedSqlOutputArgs, opts ...InvokeOption) GetSqlFirewallAllowedSqlResultOutput

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

    public static class GetSqlFirewallAllowedSql 
{
    public static Task<GetSqlFirewallAllowedSqlResult> InvokeAsync(GetSqlFirewallAllowedSqlArgs args, InvokeOptions? opts = null)
    public static Output<GetSqlFirewallAllowedSqlResult> Invoke(GetSqlFirewallAllowedSqlInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetSqlFirewallAllowedSqlResult> getSqlFirewallAllowedSql(GetSqlFirewallAllowedSqlArgs args, InvokeOptions options)
public static Output<GetSqlFirewallAllowedSqlResult> getSqlFirewallAllowedSql(GetSqlFirewallAllowedSqlArgs args, InvokeOptions options)

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

    The following arguments are supported:

    SqlFirewallAllowedSqlId string
    The OCID of the sqlFirewallAllowedSql resource.
    SqlFirewallAllowedSqlId string
    The OCID of the sqlFirewallAllowedSql resource.
    sqlFirewallAllowedSqlId String
    The OCID of the sqlFirewallAllowedSql resource.
    sqlFirewallAllowedSqlId string
    The OCID of the sqlFirewallAllowedSql resource.
    sql_firewall_allowed_sql_id str
    The OCID of the sqlFirewallAllowedSql resource.
    sqlFirewallAllowedSqlId String
    The OCID of the sqlFirewallAllowedSql resource.

    getSqlFirewallAllowedSql Result

    The following output properties are available:

    CompartmentId string
    The OCID of the compartment containing the SQL Firewall allowed SQL.
    CurrentUser string
    The name of the user that SQL was executed as.
    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 allowed SQL.
    DisplayName string
    The display name of the SQL Firewall allowed SQL.
    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 provider-assigned unique ID for this managed resource.
    SqlAccessedObjects List<string>
    The objects accessed by the SQL.
    SqlFirewallAllowedSqlId string
    SqlFirewallPolicyId string
    The OCID of the SQL Firewall policy corresponding to the SQL Firewall allowed SQL.
    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.
    SqlText string
    The SQL text of the SQL Firewall allowed SQL.
    State string
    The current state of the SQL Firewall allowed SQL.
    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"}
    TimeCollected string
    The time the the SQL Firewall allowed SQL was collected from the target database, in the format defined by RFC3339.
    TimeUpdated string
    The last date and time the SQL Firewall allowed SQL was updated, in the format defined by RFC3339.
    Version double
    Version of the associated SQL Firewall policy. This identifies whether the allowed SQLs were added in the same batch or not.
    CompartmentId string
    The OCID of the compartment containing the SQL Firewall allowed SQL.
    CurrentUser string
    The name of the user that SQL was executed as.
    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 allowed SQL.
    DisplayName string
    The display name of the SQL Firewall allowed SQL.
    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 provider-assigned unique ID for this managed resource.
    SqlAccessedObjects []string
    The objects accessed by the SQL.
    SqlFirewallAllowedSqlId string
    SqlFirewallPolicyId string
    The OCID of the SQL Firewall policy corresponding to the SQL Firewall allowed SQL.
    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.
    SqlText string
    The SQL text of the SQL Firewall allowed SQL.
    State string
    The current state of the SQL Firewall allowed SQL.
    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"}
    TimeCollected string
    The time the the SQL Firewall allowed SQL was collected from the target database, in the format defined by RFC3339.
    TimeUpdated string
    The last date and time the SQL Firewall allowed SQL was updated, in the format defined by RFC3339.
    Version float64
    Version of the associated SQL Firewall policy. This identifies whether the allowed SQLs were added in the same batch or not.
    compartmentId String
    The OCID of the compartment containing the SQL Firewall allowed SQL.
    currentUser String
    The name of the user that SQL was executed as.
    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 allowed SQL.
    displayName String
    The display name of the SQL Firewall allowed SQL.
    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 provider-assigned unique ID for this managed resource.
    sqlAccessedObjects List<String>
    The objects accessed by the SQL.
    sqlFirewallAllowedSqlId String
    sqlFirewallPolicyId String
    The OCID of the SQL Firewall policy corresponding to the SQL Firewall allowed SQL.
    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.
    sqlText String
    The SQL text of the SQL Firewall allowed SQL.
    state String
    The current state of the SQL Firewall allowed SQL.
    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"}
    timeCollected String
    The time the the SQL Firewall allowed SQL was collected from the target database, in the format defined by RFC3339.
    timeUpdated String
    The last date and time the SQL Firewall allowed SQL was updated, in the format defined by RFC3339.
    version Double
    Version of the associated SQL Firewall policy. This identifies whether the allowed SQLs were added in the same batch or not.
    compartmentId string
    The OCID of the compartment containing the SQL Firewall allowed SQL.
    currentUser string
    The name of the user that SQL was executed as.
    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 allowed SQL.
    displayName string
    The display name of the SQL Firewall allowed SQL.
    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 provider-assigned unique ID for this managed resource.
    sqlAccessedObjects string[]
    The objects accessed by the SQL.
    sqlFirewallAllowedSqlId string
    sqlFirewallPolicyId string
    The OCID of the SQL Firewall policy corresponding to the SQL Firewall allowed SQL.
    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.
    sqlText string
    The SQL text of the SQL Firewall allowed SQL.
    state string
    The current state of the SQL Firewall allowed SQL.
    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"}
    timeCollected string
    The time the the SQL Firewall allowed SQL was collected from the target database, in the format defined by RFC3339.
    timeUpdated string
    The last date and time the SQL Firewall allowed SQL was updated, in the format defined by RFC3339.
    version number
    Version of the associated SQL Firewall policy. This identifies whether the allowed SQLs were added in the same batch or not.
    compartment_id str
    The OCID of the compartment containing the SQL Firewall allowed SQL.
    current_user str
    The name of the user that SQL was executed as.
    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 allowed SQL.
    display_name str
    The display name of the SQL Firewall allowed SQL.
    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 provider-assigned unique ID for this managed resource.
    sql_accessed_objects Sequence[str]
    The objects accessed by the SQL.
    sql_firewall_allowed_sql_id str
    sql_firewall_policy_id str
    The OCID of the SQL Firewall policy corresponding to the SQL Firewall allowed SQL.
    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.
    sql_text str
    The SQL text of the SQL Firewall allowed SQL.
    state str
    The current state of the SQL Firewall allowed SQL.
    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_collected str
    The time the the SQL Firewall allowed SQL was collected from the target database, in the format defined by RFC3339.
    time_updated str
    The last date and time the SQL Firewall allowed SQL was updated, in the format defined by RFC3339.
    version float
    Version of the associated SQL Firewall policy. This identifies whether the allowed SQLs were added in the same batch or not.
    compartmentId String
    The OCID of the compartment containing the SQL Firewall allowed SQL.
    currentUser String
    The name of the user that SQL was executed as.
    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 allowed SQL.
    displayName String
    The display name of the SQL Firewall allowed SQL.
    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 provider-assigned unique ID for this managed resource.
    sqlAccessedObjects List<String>
    The objects accessed by the SQL.
    sqlFirewallAllowedSqlId String
    sqlFirewallPolicyId String
    The OCID of the SQL Firewall policy corresponding to the SQL Firewall allowed SQL.
    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.
    sqlText String
    The SQL text of the SQL Firewall allowed SQL.
    state String
    The current state of the SQL Firewall allowed SQL.
    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"}
    timeCollected String
    The time the the SQL Firewall allowed SQL was collected from the target database, in the format defined by RFC3339.
    timeUpdated String
    The last date and time the SQL Firewall allowed SQL was updated, in the format defined by RFC3339.
    version Number
    Version of the associated SQL Firewall policy. This identifies whether the allowed SQLs were added in the same batch or not.

    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.31.0 published on Thursday, Apr 17, 2025 by Pulumi
    pulumi/pulumi-oci