Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DataSafe
  5. getSqlCollections
Oracle Cloud Infrastructure v2.30.0 published on Monday, Apr 14, 2025 by Pulumi
pulumi/pulumi-oci

oci.DataSafe.getSqlCollections

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.30.0 published on Monday, Apr 14, 2025 by Pulumi
pulumi/pulumi-oci

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

    Retrieves a list of all SQL collections in Data Safe.

    The ListSqlCollections operation returns only the SQL collections 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 ListSqlCollections 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 testSqlCollections = oci.DataSafe.getSqlCollections({
    compartmentId: compartmentId,
    accessLevel: sqlCollectionAccessLevel,
    compartmentIdInSubtree: sqlCollectionCompartmentIdInSubtree,
    dbUserName: testUser.name,
    displayName: sqlCollectionDisplayName,
    sqlCollectionId: testSqlCollection.id,
    state: sqlCollectionState,
    targetId: testTarget.id,
    timeCreatedGreaterThanOrEqualTo: sqlCollectionTimeCreatedGreaterThanOrEqualTo,
    timeCreatedLessThan: sqlCollectionTimeCreatedLessThan,
});

    import pulumi
import pulumi_oci as oci

test_sql_collections = oci.DataSafe.get_sql_collections(compartment_id=compartment_id,
    access_level=sql_collection_access_level,
    compartment_id_in_subtree=sql_collection_compartment_id_in_subtree,
    db_user_name=test_user["name"],
    display_name=sql_collection_display_name,
    sql_collection_id=test_sql_collection["id"],
    state=sql_collection_state,
    target_id=test_target["id"],
    time_created_greater_than_or_equal_to=sql_collection_time_created_greater_than_or_equal_to,
    time_created_less_than=sql_collection_time_created_less_than)

    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.GetSqlCollections(ctx, &datasafe.GetSqlCollectionsArgs{
			CompartmentId:                   compartmentId,
			AccessLevel:                     pulumi.StringRef(sqlCollectionAccessLevel),
			CompartmentIdInSubtree:          pulumi.BoolRef(sqlCollectionCompartmentIdInSubtree),
			DbUserName:                      pulumi.StringRef(testUser.Name),
			DisplayName:                     pulumi.StringRef(sqlCollectionDisplayName),
			SqlCollectionId:                 pulumi.StringRef(testSqlCollection.Id),
			State:                           pulumi.StringRef(sqlCollectionState),
			TargetId:                        pulumi.StringRef(testTarget.Id),
			TimeCreatedGreaterThanOrEqualTo: pulumi.StringRef(sqlCollectionTimeCreatedGreaterThanOrEqualTo),
			TimeCreatedLessThan:             pulumi.StringRef(sqlCollectionTimeCreatedLessThan),
		}, 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 testSqlCollections = Oci.DataSafe.GetSqlCollections.Invoke(new()
    {
        CompartmentId = compartmentId,
        AccessLevel = sqlCollectionAccessLevel,
        CompartmentIdInSubtree = sqlCollectionCompartmentIdInSubtree,
        DbUserName = testUser.Name,
        DisplayName = sqlCollectionDisplayName,
        SqlCollectionId = testSqlCollection.Id,
        State = sqlCollectionState,
        TargetId = testTarget.Id,
        TimeCreatedGreaterThanOrEqualTo = sqlCollectionTimeCreatedGreaterThanOrEqualTo,
        TimeCreatedLessThan = sqlCollectionTimeCreatedLessThan,
    });

});

    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.GetSqlCollectionsArgs;
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 testSqlCollections = DataSafeFunctions.getSqlCollections(GetSqlCollectionsArgs.builder()
            .compartmentId(compartmentId)
            .accessLevel(sqlCollectionAccessLevel)
            .compartmentIdInSubtree(sqlCollectionCompartmentIdInSubtree)
            .dbUserName(testUser.name())
            .displayName(sqlCollectionDisplayName)
            .sqlCollectionId(testSqlCollection.id())
            .state(sqlCollectionState)
            .targetId(testTarget.id())
            .timeCreatedGreaterThanOrEqualTo(sqlCollectionTimeCreatedGreaterThanOrEqualTo)
            .timeCreatedLessThan(sqlCollectionTimeCreatedLessThan)
            .build());

    }
}

    variables:
  testSqlCollections:
    fn::invoke:
      function: oci:DataSafe:getSqlCollections
      arguments:
        compartmentId: ${compartmentId}
        accessLevel: ${sqlCollectionAccessLevel}
        compartmentIdInSubtree: ${sqlCollectionCompartmentIdInSubtree}
        dbUserName: ${testUser.name}
        displayName: ${sqlCollectionDisplayName}
        sqlCollectionId: ${testSqlCollection.id}
        state: ${sqlCollectionState}
        targetId: ${testTarget.id}
        timeCreatedGreaterThanOrEqualTo: ${sqlCollectionTimeCreatedGreaterThanOrEqualTo}
        timeCreatedLessThan: ${sqlCollectionTimeCreatedLessThan}

    Using getSqlCollections

    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 getSqlCollections(args: GetSqlCollectionsArgs, opts?: InvokeOptions): Promise<GetSqlCollectionsResult>
function getSqlCollectionsOutput(args: GetSqlCollectionsOutputArgs, opts?: InvokeOptions): Output<GetSqlCollectionsResult>
    def get_sql_collections(access_level: Optional[str] = None,
                        compartment_id: Optional[str] = None,
                        compartment_id_in_subtree: Optional[bool] = None,
                        db_user_name: Optional[str] = None,
                        display_name: Optional[str] = None,
                        filters: Optional[Sequence[_datasafe.GetSqlCollectionsFilter]] = None,
                        sql_collection_id: Optional[str] = None,
                        state: Optional[str] = None,
                        target_id: Optional[str] = None,
                        time_created_greater_than_or_equal_to: Optional[str] = None,
                        time_created_less_than: Optional[str] = None,
                        opts: Optional[InvokeOptions] = None) -> GetSqlCollectionsResult
def get_sql_collections_output(access_level: Optional[pulumi.Input[str]] = None,
                        compartment_id: Optional[pulumi.Input[str]] = None,
                        compartment_id_in_subtree: Optional[pulumi.Input[bool]] = None,
                        db_user_name: Optional[pulumi.Input[str]] = None,
                        display_name: Optional[pulumi.Input[str]] = None,
                        filters: Optional[pulumi.Input[Sequence[pulumi.Input[_datasafe.GetSqlCollectionsFilterArgs]]]] = None,
                        sql_collection_id: Optional[pulumi.Input[str]] = None,
                        state: Optional[pulumi.Input[str]] = None,
                        target_id: Optional[pulumi.Input[str]] = None,
                        time_created_greater_than_or_equal_to: Optional[pulumi.Input[str]] = None,
                        time_created_less_than: Optional[pulumi.Input[str]] = None,
                        opts: Optional[InvokeOptions] = None) -> Output[GetSqlCollectionsResult]
    func GetSqlCollections(ctx *Context, args *GetSqlCollectionsArgs, opts ...InvokeOption) (*GetSqlCollectionsResult, error)
func GetSqlCollectionsOutput(ctx *Context, args *GetSqlCollectionsOutputArgs, opts ...InvokeOption) GetSqlCollectionsResultOutput

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

    public static class GetSqlCollections 
{
    public static Task<GetSqlCollectionsResult> InvokeAsync(GetSqlCollectionsArgs args, InvokeOptions? opts = null)
    public static Output<GetSqlCollectionsResult> Invoke(GetSqlCollectionsInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetSqlCollectionsResult> getSqlCollections(GetSqlCollectionsArgs args, InvokeOptions options)
public static Output<GetSqlCollectionsResult> getSqlCollections(GetSqlCollectionsArgs args, InvokeOptions options)

    fn::invoke:
  function: oci:DataSafe/getSqlCollections:getSqlCollections
  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.
    DbUserName string
    A filter to return only items that match the specified user name.
    DisplayName string
    A filter to return only resources that match the specified display name.
    Filters List<GetSqlCollectionsFilter>
    SqlCollectionId string
    An optional filter to return only resources that match the specified OCID of the SQL collection resource.
    State string
    The current state of the SQL collection.
    TargetId string
    A filter to return only items related to a specific target OCID.
    TimeCreatedGreaterThanOrEqualTo string

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

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

    TimeCreatedLessThan string

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

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

    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.
    DbUserName string
    A filter to return only items that match the specified user name.
    DisplayName string
    A filter to return only resources that match the specified display name.
    Filters []GetSqlCollectionsFilter
    SqlCollectionId string
    An optional filter to return only resources that match the specified OCID of the SQL collection resource.
    State string
    The current state of the SQL collection.
    TargetId string
    A filter to return only items related to a specific target OCID.
    TimeCreatedGreaterThanOrEqualTo string

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

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

    TimeCreatedLessThan string

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

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

    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.
    dbUserName String
    A filter to return only items that match the specified user name.
    displayName String
    A filter to return only resources that match the specified display name.
    filters List<GetSqlCollectionsFilter>
    sqlCollectionId String
    An optional filter to return only resources that match the specified OCID of the SQL collection resource.
    state String
    The current state of the SQL collection.
    targetId String
    A filter to return only items related to a specific target OCID.
    timeCreatedGreaterThanOrEqualTo String

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

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

    timeCreatedLessThan String

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

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

    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.
    dbUserName string
    A filter to return only items that match the specified user name.
    displayName string
    A filter to return only resources that match the specified display name.
    filters GetSqlCollectionsFilter[]
    sqlCollectionId string
    An optional filter to return only resources that match the specified OCID of the SQL collection resource.
    state string
    The current state of the SQL collection.
    targetId string
    A filter to return only items related to a specific target OCID.
    timeCreatedGreaterThanOrEqualTo string

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

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

    timeCreatedLessThan string

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

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

    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.
    db_user_name str
    A filter to return only items that match the specified user name.
    display_name str
    A filter to return only resources that match the specified display name.
    filters Sequence[datasafe.GetSqlCollectionsFilter]
    sql_collection_id str
    An optional filter to return only resources that match the specified OCID of the SQL collection resource.
    state str
    The current state of the SQL collection.
    target_id str
    A filter to return only items related to a specific target OCID.
    time_created_greater_than_or_equal_to str

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

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

    time_created_less_than str

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

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

    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.
    dbUserName String
    A filter to return only items that match the specified user name.
    displayName String
    A filter to return only resources that match the specified display name.
    filters List<Property Map>
    sqlCollectionId String
    An optional filter to return only resources that match the specified OCID of the SQL collection resource.
    state String
    The current state of the SQL collection.
    targetId String
    A filter to return only items related to a specific target OCID.
    timeCreatedGreaterThanOrEqualTo String

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

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

    timeCreatedLessThan String

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

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

    getSqlCollections Result

    The following output properties are available:

    CompartmentId string
    The OCID of the compartment containing the SQL collection.
    Id string
    The provider-assigned unique ID for this managed resource.
    SqlCollectionCollections List<GetSqlCollectionsSqlCollectionCollection>
    The list of sql_collection_collection.
    AccessLevel string
    CompartmentIdInSubtree bool
    DbUserName string
    The database user name.
    DisplayName string
    The display name of the SQL collection.
    Filters List<GetSqlCollectionsFilter>
    SqlCollectionId string
    State string
    The current state of the SQL collection.
    TargetId string
    The OCID of the target corresponding to the security policy deployment.
    TimeCreatedGreaterThanOrEqualTo string
    TimeCreatedLessThan string
    CompartmentId string
    The OCID of the compartment containing the SQL collection.
    Id string
    The provider-assigned unique ID for this managed resource.
    SqlCollectionCollections []GetSqlCollectionsSqlCollectionCollection
    The list of sql_collection_collection.
    AccessLevel string
    CompartmentIdInSubtree bool
    DbUserName string
    The database user name.
    DisplayName string
    The display name of the SQL collection.
    Filters []GetSqlCollectionsFilter
    SqlCollectionId string
    State string
    The current state of the SQL collection.
    TargetId string
    The OCID of the target corresponding to the security policy deployment.
    TimeCreatedGreaterThanOrEqualTo string
    TimeCreatedLessThan string
    compartmentId String
    The OCID of the compartment containing the SQL collection.
    id String
    The provider-assigned unique ID for this managed resource.
    sqlCollectionCollections List<GetSqlCollectionsSqlCollectionCollection>
    The list of sql_collection_collection.
    accessLevel String
    compartmentIdInSubtree Boolean
    dbUserName String
    The database user name.
    displayName String
    The display name of the SQL collection.
    filters List<GetSqlCollectionsFilter>
    sqlCollectionId String
    state String
    The current state of the SQL collection.
    targetId String
    The OCID of the target corresponding to the security policy deployment.
    timeCreatedGreaterThanOrEqualTo String
    timeCreatedLessThan String
    compartmentId string
    The OCID of the compartment containing the SQL collection.
    id string
    The provider-assigned unique ID for this managed resource.
    sqlCollectionCollections GetSqlCollectionsSqlCollectionCollection[]
    The list of sql_collection_collection.
    accessLevel string
    compartmentIdInSubtree boolean
    dbUserName string
    The database user name.
    displayName string
    The display name of the SQL collection.
    filters GetSqlCollectionsFilter[]
    sqlCollectionId string
    state string
    The current state of the SQL collection.
    targetId string
    The OCID of the target corresponding to the security policy deployment.
    timeCreatedGreaterThanOrEqualTo string
    timeCreatedLessThan string
    compartment_id str
    The OCID of the compartment containing the SQL collection.
    id str
    The provider-assigned unique ID for this managed resource.
    sql_collection_collections Sequence[datasafe.GetSqlCollectionsSqlCollectionCollection]
    The list of sql_collection_collection.
    access_level str
    compartment_id_in_subtree bool
    db_user_name str
    The database user name.
    display_name str
    The display name of the SQL collection.
    filters Sequence[datasafe.GetSqlCollectionsFilter]
    sql_collection_id str
    state str
    The current state of the SQL collection.
    target_id str
    The OCID of the target corresponding to the security policy deployment.
    time_created_greater_than_or_equal_to str
    time_created_less_than str
    compartmentId String
    The OCID of the compartment containing the SQL collection.
    id String
    The provider-assigned unique ID for this managed resource.
    sqlCollectionCollections List<Property Map>
    The list of sql_collection_collection.
    accessLevel String
    compartmentIdInSubtree Boolean
    dbUserName String
    The database user name.
    displayName String
    The display name of the SQL collection.
    filters List<Property Map>
    sqlCollectionId String
    state String
    The current state of the SQL collection.
    targetId String
    The OCID of the target corresponding to the security policy deployment.
    timeCreatedGreaterThanOrEqualTo String
    timeCreatedLessThan String

    Supporting Types

    GetSqlCollectionsFilter

    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

    GetSqlCollectionsSqlCollectionCollection

    GetSqlCollectionsSqlCollectionCollectionItem

    CompartmentId string
    A filter to return only resources that match the specified compartment OCID.
    DbUserName string
    A filter to return only items that match the specified 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 collection.
    DisplayName string
    A filter to return only resources that match the specified display name.
    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"}
    GenerateSqlFirewallPolicyTrigger bool
    Id string
    The OCID of the SQL collection.
    LifecycleDetails string
    Details about the current state of the SQL collection in Data Safe.
    PurgeLogsTrigger bool
    RefreshLogInsightsTrigger bool
    SqlLevel string
    Specifies the level of SQL that will be collected. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
    StartTrigger bool
    State string
    The current state of the SQL collection.
    Status string
    Specifies if the status of the SqlCollection. Enabled indicates that the collecting is in progress.
    StopTrigger bool
    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"}
    TargetId string
    A filter to return only items related to a specific target OCID.
    TimeCreated string
    The time that the SQL collection was created, in the format defined by RFC3339.
    TimeLastStarted string
    The timestamp of the most recent SqlCollection start operation, in the format defined by RFC3339.
    TimeLastStopped string
    The timestamp of the most recent SqlCollection stop operation, in the format defined by RFC3339.
    TimeUpdated string
    The last date and time the SQL collection was updated, in the format defined by RFC3339.
    CompartmentId string
    A filter to return only resources that match the specified compartment OCID.
    DbUserName string
    A filter to return only items that match the specified 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 collection.
    DisplayName string
    A filter to return only resources that match the specified display name.
    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"}
    GenerateSqlFirewallPolicyTrigger bool
    Id string
    The OCID of the SQL collection.
    LifecycleDetails string
    Details about the current state of the SQL collection in Data Safe.
    PurgeLogsTrigger bool
    RefreshLogInsightsTrigger bool
    SqlLevel string
    Specifies the level of SQL that will be collected. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
    StartTrigger bool
    State string
    The current state of the SQL collection.
    Status string
    Specifies if the status of the SqlCollection. Enabled indicates that the collecting is in progress.
    StopTrigger bool
    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"}
    TargetId string
    A filter to return only items related to a specific target OCID.
    TimeCreated string
    The time that the SQL collection was created, in the format defined by RFC3339.
    TimeLastStarted string
    The timestamp of the most recent SqlCollection start operation, in the format defined by RFC3339.
    TimeLastStopped string
    The timestamp of the most recent SqlCollection stop operation, in the format defined by RFC3339.
    TimeUpdated string
    The last date and time the SQL collection was updated, in the format defined by RFC3339.
    compartmentId String
    A filter to return only resources that match the specified compartment OCID.
    dbUserName String
    A filter to return only items that match the specified 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 collection.
    displayName String
    A filter to return only resources that match the specified display name.
    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"}
    generateSqlFirewallPolicyTrigger Boolean
    id String
    The OCID of the SQL collection.
    lifecycleDetails String
    Details about the current state of the SQL collection in Data Safe.
    purgeLogsTrigger Boolean
    refreshLogInsightsTrigger Boolean
    sqlLevel String
    Specifies the level of SQL that will be collected. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
    startTrigger Boolean
    state String
    The current state of the SQL collection.
    status String
    Specifies if the status of the SqlCollection. Enabled indicates that the collecting is in progress.
    stopTrigger Boolean
    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"}
    targetId String
    A filter to return only items related to a specific target OCID.
    timeCreated String
    The time that the SQL collection was created, in the format defined by RFC3339.
    timeLastStarted String
    The timestamp of the most recent SqlCollection start operation, in the format defined by RFC3339.
    timeLastStopped String
    The timestamp of the most recent SqlCollection stop operation, in the format defined by RFC3339.
    timeUpdated String
    The last date and time the SQL collection was updated, in the format defined by RFC3339.
    compartmentId string
    A filter to return only resources that match the specified compartment OCID.
    dbUserName string
    A filter to return only items that match the specified 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 collection.
    displayName string
    A filter to return only resources that match the specified display name.
    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"}
    generateSqlFirewallPolicyTrigger boolean
    id string
    The OCID of the SQL collection.
    lifecycleDetails string
    Details about the current state of the SQL collection in Data Safe.
    purgeLogsTrigger boolean
    refreshLogInsightsTrigger boolean
    sqlLevel string
    Specifies the level of SQL that will be collected. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
    startTrigger boolean
    state string
    The current state of the SQL collection.
    status string
    Specifies if the status of the SqlCollection. Enabled indicates that the collecting is in progress.
    stopTrigger boolean
    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"}
    targetId string
    A filter to return only items related to a specific target OCID.
    timeCreated string
    The time that the SQL collection was created, in the format defined by RFC3339.
    timeLastStarted string
    The timestamp of the most recent SqlCollection start operation, in the format defined by RFC3339.
    timeLastStopped string
    The timestamp of the most recent SqlCollection stop operation, in the format defined by RFC3339.
    timeUpdated string
    The last date and time the SQL collection was updated, in the format defined by RFC3339.
    compartment_id str
    A filter to return only resources that match the specified compartment OCID.
    db_user_name str
    A filter to return only items that match the specified 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 collection.
    display_name str
    A filter to return only resources that match the specified display name.
    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"}
    generate_sql_firewall_policy_trigger bool
    id str
    The OCID of the SQL collection.
    lifecycle_details str
    Details about the current state of the SQL collection in Data Safe.
    purge_logs_trigger bool
    refresh_log_insights_trigger bool
    sql_level str
    Specifies the level of SQL that will be collected. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
    start_trigger bool
    state str
    The current state of the SQL collection.
    status str
    Specifies if the status of the SqlCollection. Enabled indicates that the collecting is in progress.
    stop_trigger bool
    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"}
    target_id str
    A filter to return only items related to a specific target OCID.
    time_created str
    The time that the SQL collection was created, in the format defined by RFC3339.
    time_last_started str
    The timestamp of the most recent SqlCollection start operation, in the format defined by RFC3339.
    time_last_stopped str
    The timestamp of the most recent SqlCollection stop operation, in the format defined by RFC3339.
    time_updated str
    The last date and time the SQL collection was updated, in the format defined by RFC3339.
    compartmentId String
    A filter to return only resources that match the specified compartment OCID.
    dbUserName String
    A filter to return only items that match the specified 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 collection.
    displayName String
    A filter to return only resources that match the specified display name.
    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"}
    generateSqlFirewallPolicyTrigger Boolean
    id String
    The OCID of the SQL collection.
    lifecycleDetails String
    Details about the current state of the SQL collection in Data Safe.
    purgeLogsTrigger Boolean
    refreshLogInsightsTrigger Boolean
    sqlLevel String
    Specifies the level of SQL that will be collected. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
    startTrigger Boolean
    state String
    The current state of the SQL collection.
    status String
    Specifies if the status of the SqlCollection. Enabled indicates that the collecting is in progress.
    stopTrigger Boolean
    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"}
    targetId String
    A filter to return only items related to a specific target OCID.
    timeCreated String
    The time that the SQL collection was created, in the format defined by RFC3339.
    timeLastStarted String
    The timestamp of the most recent SqlCollection start operation, in the format defined by RFC3339.
    timeLastStopped String
    The timestamp of the most recent SqlCollection stop operation, in the format defined by RFC3339.
    timeUpdated String
    The last date and time the SQL collection was updated, in the format defined by RFC3339.

    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.30.0 published on Monday, Apr 14, 2025 by Pulumi
    pulumi/pulumi-oci