Docs Home Pulumi IaC Pulumi ESC Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DataSafe
  5. getSqlFirewallAllowedSqlAnalytics
Oracle Cloud Infrastructure v2.17.0 published on Friday, Nov 15, 2024 by Pulumi
pulumi/pulumi-oci

oci.DataSafe.getSqlFirewallAllowedSqlAnalytics

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.17.0 published on Friday, Nov 15, 2024 by Pulumi
pulumi/pulumi-oci

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

    Returns the aggregation details of all SQL Firewall allowed SQL statements.

    The ListSqlFirewallAllowedSqlAnalytics operation returns the aggregates of the SQL Firewall allowed SQL statements 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 ListSqlFirewallAllowedSqlAnalytics 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 testSqlFirewallAllowedSqlAnalytics = oci.DataSafe.getSqlFirewallAllowedSqlAnalytics({
    compartmentId: compartmentId,
    accessLevel: sqlFirewallAllowedSqlAnalyticAccessLevel,
    compartmentIdInSubtree: sqlFirewallAllowedSqlAnalyticCompartmentIdInSubtree,
    groupBies: sqlFirewallAllowedSqlAnalyticGroupBy,
    scimQuery: sqlFirewallAllowedSqlAnalyticScimQuery,
});

    import pulumi
import pulumi_oci as oci

test_sql_firewall_allowed_sql_analytics = oci.DataSafe.get_sql_firewall_allowed_sql_analytics(compartment_id=compartment_id,
    access_level=sql_firewall_allowed_sql_analytic_access_level,
    compartment_id_in_subtree=sql_firewall_allowed_sql_analytic_compartment_id_in_subtree,
    group_bies=sql_firewall_allowed_sql_analytic_group_by,
    scim_query=sql_firewall_allowed_sql_analytic_scim_query)

    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.GetSqlFirewallAllowedSqlAnalytics(ctx, &datasafe.GetSqlFirewallAllowedSqlAnalyticsArgs{
			CompartmentId:          compartmentId,
			AccessLevel:            pulumi.StringRef(sqlFirewallAllowedSqlAnalyticAccessLevel),
			CompartmentIdInSubtree: pulumi.BoolRef(sqlFirewallAllowedSqlAnalyticCompartmentIdInSubtree),
			GroupBies:              sqlFirewallAllowedSqlAnalyticGroupBy,
			ScimQuery:              pulumi.StringRef(sqlFirewallAllowedSqlAnalyticScimQuery),
		}, 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 testSqlFirewallAllowedSqlAnalytics = Oci.DataSafe.GetSqlFirewallAllowedSqlAnalytics.Invoke(new()
    {
        CompartmentId = compartmentId,
        AccessLevel = sqlFirewallAllowedSqlAnalyticAccessLevel,
        CompartmentIdInSubtree = sqlFirewallAllowedSqlAnalyticCompartmentIdInSubtree,
        GroupBies = sqlFirewallAllowedSqlAnalyticGroupBy,
        ScimQuery = sqlFirewallAllowedSqlAnalyticScimQuery,
    });

});

    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.GetSqlFirewallAllowedSqlAnalyticsArgs;
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 testSqlFirewallAllowedSqlAnalytics = DataSafeFunctions.getSqlFirewallAllowedSqlAnalytics(GetSqlFirewallAllowedSqlAnalyticsArgs.builder()
            .compartmentId(compartmentId)
            .accessLevel(sqlFirewallAllowedSqlAnalyticAccessLevel)
            .compartmentIdInSubtree(sqlFirewallAllowedSqlAnalyticCompartmentIdInSubtree)
            .groupBies(sqlFirewallAllowedSqlAnalyticGroupBy)
            .scimQuery(sqlFirewallAllowedSqlAnalyticScimQuery)
            .build());

    }
}

    variables:
  testSqlFirewallAllowedSqlAnalytics:
    fn::invoke:
      Function: oci:DataSafe:getSqlFirewallAllowedSqlAnalytics
      Arguments:
        compartmentId: ${compartmentId}
        accessLevel: ${sqlFirewallAllowedSqlAnalyticAccessLevel}
        compartmentIdInSubtree: ${sqlFirewallAllowedSqlAnalyticCompartmentIdInSubtree}
        groupBies: ${sqlFirewallAllowedSqlAnalyticGroupBy}
        scimQuery: ${sqlFirewallAllowedSqlAnalyticScimQuery}

    Using getSqlFirewallAllowedSqlAnalytics

    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 getSqlFirewallAllowedSqlAnalytics(args: GetSqlFirewallAllowedSqlAnalyticsArgs, opts?: InvokeOptions): Promise<GetSqlFirewallAllowedSqlAnalyticsResult>
function getSqlFirewallAllowedSqlAnalyticsOutput(args: GetSqlFirewallAllowedSqlAnalyticsOutputArgs, opts?: InvokeOptions): Output<GetSqlFirewallAllowedSqlAnalyticsResult>
    def get_sql_firewall_allowed_sql_analytics(access_level: Optional[str] = None,
                                           compartment_id: Optional[str] = None,
                                           compartment_id_in_subtree: Optional[bool] = None,
                                           filters: Optional[Sequence[_datasafe.GetSqlFirewallAllowedSqlAnalyticsFilter]] = None,
                                           group_bies: Optional[Sequence[str]] = None,
                                           scim_query: Optional[str] = None,
                                           opts: Optional[InvokeOptions] = None) -> GetSqlFirewallAllowedSqlAnalyticsResult
def get_sql_firewall_allowed_sql_analytics_output(access_level: Optional[pulumi.Input[str]] = None,
                                           compartment_id: Optional[pulumi.Input[str]] = None,
                                           compartment_id_in_subtree: Optional[pulumi.Input[bool]] = None,
                                           filters: Optional[pulumi.Input[Sequence[pulumi.Input[_datasafe.GetSqlFirewallAllowedSqlAnalyticsFilterArgs]]]] = None,
                                           group_bies: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                                           scim_query: Optional[pulumi.Input[str]] = None,
                                           opts: Optional[InvokeOptions] = None) -> Output[GetSqlFirewallAllowedSqlAnalyticsResult]
    func GetSqlFirewallAllowedSqlAnalytics(ctx *Context, args *GetSqlFirewallAllowedSqlAnalyticsArgs, opts ...InvokeOption) (*GetSqlFirewallAllowedSqlAnalyticsResult, error)
func GetSqlFirewallAllowedSqlAnalyticsOutput(ctx *Context, args *GetSqlFirewallAllowedSqlAnalyticsOutputArgs, opts ...InvokeOption) GetSqlFirewallAllowedSqlAnalyticsResultOutput

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

    public static class GetSqlFirewallAllowedSqlAnalytics 
{
    public static Task<GetSqlFirewallAllowedSqlAnalyticsResult> InvokeAsync(GetSqlFirewallAllowedSqlAnalyticsArgs args, InvokeOptions? opts = null)
    public static Output<GetSqlFirewallAllowedSqlAnalyticsResult> Invoke(GetSqlFirewallAllowedSqlAnalyticsInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetSqlFirewallAllowedSqlAnalyticsResult> getSqlFirewallAllowedSqlAnalytics(GetSqlFirewallAllowedSqlAnalyticsArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

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

    The following arguments are supported:

    CompartmentId 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.
    Filters List<GetSqlFirewallAllowedSqlAnalyticsFilter>
    GroupBies List<string>
    The group by parameter to summarize the allowed SQL aggregation.
    ScimQuery string

    The scimQuery query parameter accepts filter expressions that use the syntax described in Section 3.2.2.2 of the System for Cross-Domain Identity Management (SCIM) specification, which is available at RFC3339. In SCIM filtering expressions, text, date, and time values must be enclosed in quotation marks, with date and time values using ISO-8601 format. (Numeric and boolean values should not be quoted.)

    Example: query=(currentUser eq 'SCOTT') and (topLevel eq 'YES')

    CompartmentId 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.
    Filters []GetSqlFirewallAllowedSqlAnalyticsFilter
    GroupBies []string
    The group by parameter to summarize the allowed SQL aggregation.
    ScimQuery string

    The scimQuery query parameter accepts filter expressions that use the syntax described in Section 3.2.2.2 of the System for Cross-Domain Identity Management (SCIM) specification, which is available at RFC3339. In SCIM filtering expressions, text, date, and time values must be enclosed in quotation marks, with date and time values using ISO-8601 format. (Numeric and boolean values should not be quoted.)

    Example: query=(currentUser eq 'SCOTT') and (topLevel eq 'YES')

    compartmentId 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.
    filters List<GetSqlFirewallAllowedSqlAnalyticsFilter>
    groupBies List<String>
    The group by parameter to summarize the allowed SQL aggregation.
    scimQuery String

    The scimQuery query parameter accepts filter expressions that use the syntax described in Section 3.2.2.2 of the System for Cross-Domain Identity Management (SCIM) specification, which is available at RFC3339. In SCIM filtering expressions, text, date, and time values must be enclosed in quotation marks, with date and time values using ISO-8601 format. (Numeric and boolean values should not be quoted.)

    Example: query=(currentUser eq 'SCOTT') and (topLevel eq 'YES')

    compartmentId 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.
    filters GetSqlFirewallAllowedSqlAnalyticsFilter[]
    groupBies string[]
    The group by parameter to summarize the allowed SQL aggregation.
    scimQuery string

    The scimQuery query parameter accepts filter expressions that use the syntax described in Section 3.2.2.2 of the System for Cross-Domain Identity Management (SCIM) specification, which is available at RFC3339. In SCIM filtering expressions, text, date, and time values must be enclosed in quotation marks, with date and time values using ISO-8601 format. (Numeric and boolean values should not be quoted.)

    Example: query=(currentUser eq 'SCOTT') and (topLevel eq 'YES')

    compartment_id 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.
    filters Sequence[datasafe.GetSqlFirewallAllowedSqlAnalyticsFilter]
    group_bies Sequence[str]
    The group by parameter to summarize the allowed SQL aggregation.
    scim_query str

    The scimQuery query parameter accepts filter expressions that use the syntax described in Section 3.2.2.2 of the System for Cross-Domain Identity Management (SCIM) specification, which is available at RFC3339. In SCIM filtering expressions, text, date, and time values must be enclosed in quotation marks, with date and time values using ISO-8601 format. (Numeric and boolean values should not be quoted.)

    Example: query=(currentUser eq 'SCOTT') and (topLevel eq 'YES')

    compartmentId 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.
    filters List<Property Map>
    groupBies List<String>
    The group by parameter to summarize the allowed SQL aggregation.
    scimQuery String

    The scimQuery query parameter accepts filter expressions that use the syntax described in Section 3.2.2.2 of the System for Cross-Domain Identity Management (SCIM) specification, which is available at RFC3339. In SCIM filtering expressions, text, date, and time values must be enclosed in quotation marks, with date and time values using ISO-8601 format. (Numeric and boolean values should not be quoted.)

    Example: query=(currentUser eq 'SCOTT') and (topLevel eq 'YES')

    getSqlFirewallAllowedSqlAnalytics Result

    The following output properties are available:

    CompartmentId string
    Id string
    The provider-assigned unique ID for this managed resource.
    SqlFirewallAllowedSqlAnalyticsCollections List<GetSqlFirewallAllowedSqlAnalyticsSqlFirewallAllowedSqlAnalyticsCollection>
    The list of sql_firewall_allowed_sql_analytics_collection.
    AccessLevel string
    CompartmentIdInSubtree bool
    Filters List<GetSqlFirewallAllowedSqlAnalyticsFilter>
    GroupBies List<string>
    ScimQuery string
    CompartmentId string
    Id string
    The provider-assigned unique ID for this managed resource.
    SqlFirewallAllowedSqlAnalyticsCollections []GetSqlFirewallAllowedSqlAnalyticsSqlFirewallAllowedSqlAnalyticsCollection
    The list of sql_firewall_allowed_sql_analytics_collection.
    AccessLevel string
    CompartmentIdInSubtree bool
    Filters []GetSqlFirewallAllowedSqlAnalyticsFilter
    GroupBies []string
    ScimQuery string
    compartmentId String
    id String
    The provider-assigned unique ID for this managed resource.
    sqlFirewallAllowedSqlAnalyticsCollections List<GetSqlFirewallAllowedSqlAnalyticsSqlFirewallAllowedSqlAnalyticsCollection>
    The list of sql_firewall_allowed_sql_analytics_collection.
    accessLevel String
    compartmentIdInSubtree Boolean
    filters List<GetSqlFirewallAllowedSqlAnalyticsFilter>
    groupBies List<String>
    scimQuery String
    compartmentId string
    id string
    The provider-assigned unique ID for this managed resource.
    sqlFirewallAllowedSqlAnalyticsCollections GetSqlFirewallAllowedSqlAnalyticsSqlFirewallAllowedSqlAnalyticsCollection[]
    The list of sql_firewall_allowed_sql_analytics_collection.
    accessLevel string
    compartmentIdInSubtree boolean
    filters GetSqlFirewallAllowedSqlAnalyticsFilter[]
    groupBies string[]
    scimQuery string
    compartmentId String
    id String
    The provider-assigned unique ID for this managed resource.
    sqlFirewallAllowedSqlAnalyticsCollections List<Property Map>
    The list of sql_firewall_allowed_sql_analytics_collection.
    accessLevel String
    compartmentIdInSubtree Boolean
    filters List<Property Map>
    groupBies List<String>
    scimQuery String

    Supporting Types

    GetSqlFirewallAllowedSqlAnalyticsFilter

    Name string
    Values List<string>
    Regex bool
    Name string
    Values []string
    Regex bool
    name String
    values List<String>
    regex Boolean
    name string
    values string[]
    regex boolean
    name str
    values Sequence[str]
    regex bool
    name String
    values List<String>
    regex Boolean

    GetSqlFirewallAllowedSqlAnalyticsSqlFirewallAllowedSqlAnalyticsCollection

    items List<Property Map>
    The aggregated data point items.

    GetSqlFirewallAllowedSqlAnalyticsSqlFirewallAllowedSqlAnalyticsCollectionItem

    Dimensions List<GetSqlFirewallAllowedSqlAnalyticsSqlFirewallAllowedSqlAnalyticsCollectionItemDimension>
    The dimensions available for SQL Firewall allow SQL analytics.
    SqlFirewallAllowedSqlAnalyticCount string
    The total count of the aggregated metric.
    Dimensions []GetSqlFirewallAllowedSqlAnalyticsSqlFirewallAllowedSqlAnalyticsCollectionItemDimension
    The dimensions available for SQL Firewall allow SQL analytics.
    SqlFirewallAllowedSqlAnalyticCount string
    The total count of the aggregated metric.
    dimensions List<GetSqlFirewallAllowedSqlAnalyticsSqlFirewallAllowedSqlAnalyticsCollectionItemDimension>
    The dimensions available for SQL Firewall allow SQL analytics.
    sqlFirewallAllowedSqlAnalyticCount String
    The total count of the aggregated metric.
    dimensions GetSqlFirewallAllowedSqlAnalyticsSqlFirewallAllowedSqlAnalyticsCollectionItemDimension[]
    The dimensions available for SQL Firewall allow SQL analytics.
    sqlFirewallAllowedSqlAnalyticCount string
    The total count of the aggregated metric.
    dimensions Sequence[datasafe.GetSqlFirewallAllowedSqlAnalyticsSqlFirewallAllowedSqlAnalyticsCollectionItemDimension]
    The dimensions available for SQL Firewall allow SQL analytics.
    sql_firewall_allowed_sql_analytic_count str
    The total count of the aggregated metric.
    dimensions List<Property Map>
    The dimensions available for SQL Firewall allow SQL analytics.
    sqlFirewallAllowedSqlAnalyticCount String
    The total count of the aggregated metric.

    GetSqlFirewallAllowedSqlAnalyticsSqlFirewallAllowedSqlAnalyticsCollectionItemDimension

    DbUserName string
    The database user name.
    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.
    State string
    The current state of the SQL Firewall allowed SQL.
    DbUserName string
    The database user name.
    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.
    State string
    The current state of the SQL Firewall allowed SQL.
    dbUserName String
    The database user name.
    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.
    state String
    The current state of the SQL Firewall allowed SQL.
    dbUserName string
    The database user name.
    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.
    state string
    The current state of the SQL Firewall allowed SQL.
    db_user_name str
    The database user name.
    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.
    state str
    The current state of the SQL Firewall allowed SQL.
    dbUserName String
    The database user name.
    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.
    state String
    The current state of the SQL Firewall allowed SQL.

    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.17.0 published on Friday, Nov 15, 2024 by Pulumi
    pulumi/pulumi-oci