import * as pulumi from "@pulumi/pulumi"; import * as inputs from "../types/input"; import * as outputs from "../types/output"; /** * 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 * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as oci from "@pulumi/oci"; * * const testSqlCollections = oci.datasafe.getSqlCollections({ * compartmentId: compartmentId, * accessLevel: sqlCollectionAccessLevel, * compartmentIdInSubtree: sqlCollectionCompartmentIdInSubtree === "true", * dbUserName: testUser.name, * displayName: sqlCollectionDisplayName, * sqlCollectionId: testSqlCollection.id, * state: sqlCollectionState, * targetDatabaseGroupId: testTargetDatabaseGroup.id, * targetId: testTarget.id, * timeCreatedGreaterThanOrEqualTo: sqlCollectionTimeCreatedGreaterThanOrEqualTo, * timeCreatedLessThan: sqlCollectionTimeCreatedLessThan, * }); * ``` */ export declare function getSqlCollections(args: GetSqlCollectionsArgs, opts?: pulumi.InvokeOptions): Promise; /** * A collection of arguments for invoking getSqlCollections. */ export interface GetSqlCollectionsArgs { /** * 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. */ accessLevel?: string; /** * A filter to return only resources that match the specified compartment OCID. */ compartmentId: string; /** * 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. */ compartmentIdInSubtree?: boolean; /** * A filter to return only items that match the specified user name. */ dbUserName?: string; /** * A filter to return only resources that match the specified display name. */ displayName?: string; filters?: inputs.DataSafe.GetSqlCollectionsFilter[]; /** * An optional filter to return only resources that match the specified OCID of the SQL collection resource. */ sqlCollectionId?: string; /** * The current state of the SQL collection. */ state?: string; /** * A filter to return the target database group that matches the specified OCID. */ targetDatabaseGroupId?: string; /** * A filter to return only items related to a specific target OCID. */ targetId?: string; /** * A filter to return only the resources that were created after the specified date and time, as defined by [RFC3339](https://tools.ietf.org/html/rfc3339). Using TimeCreatedGreaterThanOrEqualToQueryParam parameter retrieves all resources created after that date. * * **Example:** 2016-12-19T16:39:57.600Z */ timeCreatedGreaterThanOrEqualTo?: 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 */ timeCreatedLessThan?: string; } /** * A collection of values returned by getSqlCollections. */ export interface GetSqlCollectionsResult { readonly accessLevel?: string; /** * The OCID of the compartment containing the SQL collection. */ readonly compartmentId: string; readonly compartmentIdInSubtree?: boolean; /** * The database user name. */ readonly dbUserName?: string; /** * The display name of the SQL collection. */ readonly displayName?: string; readonly filters?: outputs.DataSafe.GetSqlCollectionsFilter[]; /** * The provider-assigned unique ID for this managed resource. */ readonly id: string; /** * The list of sql_collection_collection. */ readonly sqlCollectionCollections: outputs.DataSafe.GetSqlCollectionsSqlCollectionCollection[]; readonly sqlCollectionId?: string; /** * The current state of the SQL collection. */ readonly state?: string; readonly targetDatabaseGroupId?: string; /** * The OCID of the target corresponding to the security policy deployment. */ readonly targetId?: string; readonly timeCreatedGreaterThanOrEqualTo?: string; readonly timeCreatedLessThan?: string; } /** * 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 * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as oci from "@pulumi/oci"; * * const testSqlCollections = oci.datasafe.getSqlCollections({ * compartmentId: compartmentId, * accessLevel: sqlCollectionAccessLevel, * compartmentIdInSubtree: sqlCollectionCompartmentIdInSubtree === "true", * dbUserName: testUser.name, * displayName: sqlCollectionDisplayName, * sqlCollectionId: testSqlCollection.id, * state: sqlCollectionState, * targetDatabaseGroupId: testTargetDatabaseGroup.id, * targetId: testTarget.id, * timeCreatedGreaterThanOrEqualTo: sqlCollectionTimeCreatedGreaterThanOrEqualTo, * timeCreatedLessThan: sqlCollectionTimeCreatedLessThan, * }); * ``` */ export declare function getSqlCollectionsOutput(args: GetSqlCollectionsOutputArgs, opts?: pulumi.InvokeOutputOptions): pulumi.Output; /** * A collection of arguments for invoking getSqlCollections. */ export interface GetSqlCollectionsOutputArgs { /** * 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. */ accessLevel?: pulumi.Input; /** * A filter to return only resources that match the specified compartment OCID. */ compartmentId: pulumi.Input; /** * 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. */ compartmentIdInSubtree?: pulumi.Input; /** * A filter to return only items that match the specified user name. */ dbUserName?: pulumi.Input; /** * A filter to return only resources that match the specified display name. */ displayName?: pulumi.Input; filters?: pulumi.Input[] | undefined>; /** * An optional filter to return only resources that match the specified OCID of the SQL collection resource. */ sqlCollectionId?: pulumi.Input; /** * The current state of the SQL collection. */ state?: pulumi.Input; /** * A filter to return the target database group that matches the specified OCID. */ targetDatabaseGroupId?: pulumi.Input; /** * A filter to return only items related to a specific target OCID. */ targetId?: pulumi.Input; /** * A filter to return only the resources that were created after the specified date and time, as defined by [RFC3339](https://tools.ietf.org/html/rfc3339). Using TimeCreatedGreaterThanOrEqualToQueryParam parameter retrieves all resources created after that date. * * **Example:** 2016-12-19T16:39:57.600Z */ timeCreatedGreaterThanOrEqualTo?: pulumi.Input; /** * 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 */ timeCreatedLessThan?: pulumi.Input; } //# sourceMappingURL=getSqlCollections.d.ts.map