1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DataSafe
  5. getSqlFirewallViolations
Oracle Cloud Infrastructure v2.28.0 published on Thursday, Mar 27, 2025 by Pulumi

oci.DataSafe.getSqlFirewallViolations

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.28.0 published on Thursday, Mar 27, 2025 by Pulumi

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

Gets a list of all the SQL Firewall violations captured by the firewall.

Example Usage

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

const testSqlFirewallViolations = oci.DataSafe.getSqlFirewallViolations({
    compartmentId: compartmentId,
    accessLevel: sqlFirewallViolationAccessLevel,
    compartmentIdInSubtree: sqlFirewallViolationCompartmentIdInSubtree,
    scimQuery: sqlFirewallViolationScimQuery,
});
Copy
import pulumi
import pulumi_oci as oci

test_sql_firewall_violations = oci.DataSafe.get_sql_firewall_violations(compartment_id=compartment_id,
    access_level=sql_firewall_violation_access_level,
    compartment_id_in_subtree=sql_firewall_violation_compartment_id_in_subtree,
    scim_query=sql_firewall_violation_scim_query)
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.GetSqlFirewallViolations(ctx, &datasafe.GetSqlFirewallViolationsArgs{
			CompartmentId:          compartmentId,
			AccessLevel:            pulumi.StringRef(sqlFirewallViolationAccessLevel),
			CompartmentIdInSubtree: pulumi.BoolRef(sqlFirewallViolationCompartmentIdInSubtree),
			ScimQuery:              pulumi.StringRef(sqlFirewallViolationScimQuery),
		}, 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 testSqlFirewallViolations = Oci.DataSafe.GetSqlFirewallViolations.Invoke(new()
    {
        CompartmentId = compartmentId,
        AccessLevel = sqlFirewallViolationAccessLevel,
        CompartmentIdInSubtree = sqlFirewallViolationCompartmentIdInSubtree,
        ScimQuery = sqlFirewallViolationScimQuery,
    });

});
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.GetSqlFirewallViolationsArgs;
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 testSqlFirewallViolations = DataSafeFunctions.getSqlFirewallViolations(GetSqlFirewallViolationsArgs.builder()
            .compartmentId(compartmentId)
            .accessLevel(sqlFirewallViolationAccessLevel)
            .compartmentIdInSubtree(sqlFirewallViolationCompartmentIdInSubtree)
            .scimQuery(sqlFirewallViolationScimQuery)
            .build());

    }
}
Copy
variables:
  testSqlFirewallViolations:
    fn::invoke:
      function: oci:DataSafe:getSqlFirewallViolations
      arguments:
        compartmentId: ${compartmentId}
        accessLevel: ${sqlFirewallViolationAccessLevel}
        compartmentIdInSubtree: ${sqlFirewallViolationCompartmentIdInSubtree}
        scimQuery: ${sqlFirewallViolationScimQuery}
Copy

Using getSqlFirewallViolations

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 getSqlFirewallViolations(args: GetSqlFirewallViolationsArgs, opts?: InvokeOptions): Promise<GetSqlFirewallViolationsResult>
function getSqlFirewallViolationsOutput(args: GetSqlFirewallViolationsOutputArgs, opts?: InvokeOptions): Output<GetSqlFirewallViolationsResult>
Copy
def get_sql_firewall_violations(access_level: Optional[str] = None,
                                compartment_id: Optional[str] = None,
                                compartment_id_in_subtree: Optional[bool] = None,
                                filters: Optional[Sequence[_datasafe.GetSqlFirewallViolationsFilter]] = None,
                                scim_query: Optional[str] = None,
                                opts: Optional[InvokeOptions] = None) -> GetSqlFirewallViolationsResult
def get_sql_firewall_violations_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.GetSqlFirewallViolationsFilterArgs]]]] = None,
                                scim_query: Optional[pulumi.Input[str]] = None,
                                opts: Optional[InvokeOptions] = None) -> Output[GetSqlFirewallViolationsResult]
Copy
func GetSqlFirewallViolations(ctx *Context, args *GetSqlFirewallViolationsArgs, opts ...InvokeOption) (*GetSqlFirewallViolationsResult, error)
func GetSqlFirewallViolationsOutput(ctx *Context, args *GetSqlFirewallViolationsOutputArgs, opts ...InvokeOption) GetSqlFirewallViolationsResultOutput
Copy

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

public static class GetSqlFirewallViolations 
{
    public static Task<GetSqlFirewallViolationsResult> InvokeAsync(GetSqlFirewallViolationsArgs args, InvokeOptions? opts = null)
    public static Output<GetSqlFirewallViolationsResult> Invoke(GetSqlFirewallViolationsInvokeArgs args, InvokeOptions? opts = null)
}
Copy
public static CompletableFuture<GetSqlFirewallViolationsResult> getSqlFirewallViolations(GetSqlFirewallViolationsArgs args, InvokeOptions options)
public static Output<GetSqlFirewallViolationsResult> getSqlFirewallViolations(GetSqlFirewallViolationsArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: oci:DataSafe/getSqlFirewallViolations:getSqlFirewallViolations
  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.
Filters Changes to this property will trigger replacement. List<GetSqlFirewallViolationsFilter>
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=(operationTime ge '2021-06-04T01-00-26') and (violationAction eq 'BLOCKED')

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.
Filters Changes to this property will trigger replacement. []GetSqlFirewallViolationsFilter
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=(operationTime ge '2021-06-04T01-00-26') and (violationAction eq 'BLOCKED')

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.
filters Changes to this property will trigger replacement. List<GetSqlFirewallViolationsFilter>
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=(operationTime ge '2021-06-04T01-00-26') and (violationAction eq 'BLOCKED')

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.
filters Changes to this property will trigger replacement. GetSqlFirewallViolationsFilter[]
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=(operationTime ge '2021-06-04T01-00-26') and (violationAction eq 'BLOCKED')

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.
filters Changes to this property will trigger replacement. Sequence[datasafe.GetSqlFirewallViolationsFilter]
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=(operationTime ge '2021-06-04T01-00-26') and (violationAction eq 'BLOCKED')

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.
filters Changes to this property will trigger replacement. List<Property Map>
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=(operationTime ge '2021-06-04T01-00-26') and (violationAction eq 'BLOCKED')

getSqlFirewallViolations Result

The following output properties are available:

CompartmentId string
The OCID of the compartment containing the SQL violation.
Id string
The provider-assigned unique ID for this managed resource.
SqlFirewallViolationsCollections List<GetSqlFirewallViolationsSqlFirewallViolationsCollection>
The list of sql_firewall_violations_collection.
AccessLevel string
CompartmentIdInSubtree bool
Filters List<GetSqlFirewallViolationsFilter>
ScimQuery string
CompartmentId string
The OCID of the compartment containing the SQL violation.
Id string
The provider-assigned unique ID for this managed resource.
SqlFirewallViolationsCollections []GetSqlFirewallViolationsSqlFirewallViolationsCollection
The list of sql_firewall_violations_collection.
AccessLevel string
CompartmentIdInSubtree bool
Filters []GetSqlFirewallViolationsFilter
ScimQuery string
compartmentId String
The OCID of the compartment containing the SQL violation.
id String
The provider-assigned unique ID for this managed resource.
sqlFirewallViolationsCollections List<GetSqlFirewallViolationsSqlFirewallViolationsCollection>
The list of sql_firewall_violations_collection.
accessLevel String
compartmentIdInSubtree Boolean
filters List<GetSqlFirewallViolationsFilter>
scimQuery String
compartmentId string
The OCID of the compartment containing the SQL violation.
id string
The provider-assigned unique ID for this managed resource.
sqlFirewallViolationsCollections GetSqlFirewallViolationsSqlFirewallViolationsCollection[]
The list of sql_firewall_violations_collection.
accessLevel string
compartmentIdInSubtree boolean
filters GetSqlFirewallViolationsFilter[]
scimQuery string
compartment_id str
The OCID of the compartment containing the SQL violation.
id str
The provider-assigned unique ID for this managed resource.
sql_firewall_violations_collections Sequence[datasafe.GetSqlFirewallViolationsSqlFirewallViolationsCollection]
The list of sql_firewall_violations_collection.
access_level str
compartment_id_in_subtree bool
filters Sequence[datasafe.GetSqlFirewallViolationsFilter]
scim_query str
compartmentId String
The OCID of the compartment containing the SQL violation.
id String
The provider-assigned unique ID for this managed resource.
sqlFirewallViolationsCollections List<Property Map>
The list of sql_firewall_violations_collection.
accessLevel String
compartmentIdInSubtree Boolean
filters List<Property Map>
scimQuery String

Supporting Types

GetSqlFirewallViolationsFilter

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

GetSqlFirewallViolationsSqlFirewallViolationsCollection

Items This property is required. List<GetSqlFirewallViolationsSqlFirewallViolationsCollectionItem>
Array of SQL violation summary.
Items This property is required. []GetSqlFirewallViolationsSqlFirewallViolationsCollectionItem
Array of SQL violation summary.
items This property is required. List<GetSqlFirewallViolationsSqlFirewallViolationsCollectionItem>
Array of SQL violation summary.
items This property is required. GetSqlFirewallViolationsSqlFirewallViolationsCollectionItem[]
Array of SQL violation summary.
items This property is required. Sequence[datasafe.GetSqlFirewallViolationsSqlFirewallViolationsCollectionItem]
Array of SQL violation summary.
items This property is required. List<Property Map>
Array of SQL violation summary.

GetSqlFirewallViolationsSqlFirewallViolationsCollectionItem

ClientIp This property is required. string
The IP address of the host machine from which the session was generated.
ClientOsUserName This property is required. string
The name of the operating system user for the database session.
ClientProgram This property is required. string
The application from which the SQL violation was generated. Examples include SQL Plus or SQL Developer.
CompartmentId This property is required. string
A filter to return only resources that match the specified compartment OCID.
CurrentDbUserName This property is required. string
The name of the user that SQL was executed as.
DbUserName This property is required. string
The name of the database user.
Id This property is required. string
The OCID of the SQL violation.
Operation This property is required. string
The name of the action executed by the user on the target database. For example, ALTER, CREATE, DROP.
OperationTime This property is required. string
The time of the SQL violation occurrence in the target database.
SqlAccessedObjects This property is required. string
The objects accessed by the SQL.
SqlLevel This property is required. string
Specifies the level of SQL for this violation. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
SqlText This property is required. string
The SQL text caught by the firewall.
TargetId This property is required. string
The OCID of the target database.
TargetName This property is required. string
The name of the target database.
TimeCollected This property is required. string
The timestamp when this SQL violation was collected from the target database by Data Safe.
ViolationAction This property is required. string
The action taken for this SQL violation.
ViolationCause This property is required. string
Indicates whether SQL or context violation.
ClientIp This property is required. string
The IP address of the host machine from which the session was generated.
ClientOsUserName This property is required. string
The name of the operating system user for the database session.
ClientProgram This property is required. string
The application from which the SQL violation was generated. Examples include SQL Plus or SQL Developer.
CompartmentId This property is required. string
A filter to return only resources that match the specified compartment OCID.
CurrentDbUserName This property is required. string
The name of the user that SQL was executed as.
DbUserName This property is required. string
The name of the database user.
Id This property is required. string
The OCID of the SQL violation.
Operation This property is required. string
The name of the action executed by the user on the target database. For example, ALTER, CREATE, DROP.
OperationTime This property is required. string
The time of the SQL violation occurrence in the target database.
SqlAccessedObjects This property is required. string
The objects accessed by the SQL.
SqlLevel This property is required. string
Specifies the level of SQL for this violation. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
SqlText This property is required. string
The SQL text caught by the firewall.
TargetId This property is required. string
The OCID of the target database.
TargetName This property is required. string
The name of the target database.
TimeCollected This property is required. string
The timestamp when this SQL violation was collected from the target database by Data Safe.
ViolationAction This property is required. string
The action taken for this SQL violation.
ViolationCause This property is required. string
Indicates whether SQL or context violation.
clientIp This property is required. String
The IP address of the host machine from which the session was generated.
clientOsUserName This property is required. String
The name of the operating system user for the database session.
clientProgram This property is required. String
The application from which the SQL violation was generated. Examples include SQL Plus or SQL Developer.
compartmentId This property is required. String
A filter to return only resources that match the specified compartment OCID.
currentDbUserName This property is required. String
The name of the user that SQL was executed as.
dbUserName This property is required. String
The name of the database user.
id This property is required. String
The OCID of the SQL violation.
operation This property is required. String
The name of the action executed by the user on the target database. For example, ALTER, CREATE, DROP.
operationTime This property is required. String
The time of the SQL violation occurrence in the target database.
sqlAccessedObjects This property is required. String
The objects accessed by the SQL.
sqlLevel This property is required. String
Specifies the level of SQL for this violation. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
sqlText This property is required. String
The SQL text caught by the firewall.
targetId This property is required. String
The OCID of the target database.
targetName This property is required. String
The name of the target database.
timeCollected This property is required. String
The timestamp when this SQL violation was collected from the target database by Data Safe.
violationAction This property is required. String
The action taken for this SQL violation.
violationCause This property is required. String
Indicates whether SQL or context violation.
clientIp This property is required. string
The IP address of the host machine from which the session was generated.
clientOsUserName This property is required. string
The name of the operating system user for the database session.
clientProgram This property is required. string
The application from which the SQL violation was generated. Examples include SQL Plus or SQL Developer.
compartmentId This property is required. string
A filter to return only resources that match the specified compartment OCID.
currentDbUserName This property is required. string
The name of the user that SQL was executed as.
dbUserName This property is required. string
The name of the database user.
id This property is required. string
The OCID of the SQL violation.
operation This property is required. string
The name of the action executed by the user on the target database. For example, ALTER, CREATE, DROP.
operationTime This property is required. string
The time of the SQL violation occurrence in the target database.
sqlAccessedObjects This property is required. string
The objects accessed by the SQL.
sqlLevel This property is required. string
Specifies the level of SQL for this violation. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
sqlText This property is required. string
The SQL text caught by the firewall.
targetId This property is required. string
The OCID of the target database.
targetName This property is required. string
The name of the target database.
timeCollected This property is required. string
The timestamp when this SQL violation was collected from the target database by Data Safe.
violationAction This property is required. string
The action taken for this SQL violation.
violationCause This property is required. string
Indicates whether SQL or context violation.
client_ip This property is required. str
The IP address of the host machine from which the session was generated.
client_os_user_name This property is required. str
The name of the operating system user for the database session.
client_program This property is required. str
The application from which the SQL violation was generated. Examples include SQL Plus or SQL Developer.
compartment_id This property is required. str
A filter to return only resources that match the specified compartment OCID.
current_db_user_name This property is required. str
The name of the user that SQL was executed as.
db_user_name This property is required. str
The name of the database user.
id This property is required. str
The OCID of the SQL violation.
operation This property is required. str
The name of the action executed by the user on the target database. For example, ALTER, CREATE, DROP.
operation_time This property is required. str
The time of the SQL violation occurrence in the target database.
sql_accessed_objects This property is required. str
The objects accessed by the SQL.
sql_level This property is required. str
Specifies the level of SQL for this violation. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
sql_text This property is required. str
The SQL text caught by the firewall.
target_id This property is required. str
The OCID of the target database.
target_name This property is required. str
The name of the target database.
time_collected This property is required. str
The timestamp when this SQL violation was collected from the target database by Data Safe.
violation_action This property is required. str
The action taken for this SQL violation.
violation_cause This property is required. str
Indicates whether SQL or context violation.
clientIp This property is required. String
The IP address of the host machine from which the session was generated.
clientOsUserName This property is required. String
The name of the operating system user for the database session.
clientProgram This property is required. String
The application from which the SQL violation was generated. Examples include SQL Plus or SQL Developer.
compartmentId This property is required. String
A filter to return only resources that match the specified compartment OCID.
currentDbUserName This property is required. String
The name of the user that SQL was executed as.
dbUserName This property is required. String
The name of the database user.
id This property is required. String
The OCID of the SQL violation.
operation This property is required. String
The name of the action executed by the user on the target database. For example, ALTER, CREATE, DROP.
operationTime This property is required. String
The time of the SQL violation occurrence in the target database.
sqlAccessedObjects This property is required. String
The objects accessed by the SQL.
sqlLevel This property is required. String
Specifies the level of SQL for this violation. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
sqlText This property is required. String
The SQL text caught by the firewall.
targetId This property is required. String
The OCID of the target database.
targetName This property is required. String
The name of the target database.
timeCollected This property is required. String
The timestamp when this SQL violation was collected from the target database by Data Safe.
violationAction This property is required. String
The action taken for this SQL violation.
violationCause This property is required. String
Indicates whether SQL or context violation.

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.28.0 published on Thursday, Mar 27, 2025 by Pulumi