/** * * * OpenAPI spec version: 20181201 * * * NOTE: This class is auto generated by OracleSDKGenerator. * Do not edit the class manually. * * Copyright (c) 2020, 2026, Oracle and/or its affiliates. All rights reserved. * This software is dual-licensed to you under the Universal Permissive License (UPL) 1.0 as shown at https://oss.oracle.com/licenses/upl or Apache License 2.0 as shown at http://www.apache.org/licenses/LICENSE-2.0. You may choose either license. */ import * as model from "../model"; import common = require("oci-common"); /** * @example Click {@link https://docs.oracle.com/en-us/iaas/tools/typescript-sdk-examples/latest/datasafe/ListSqlFirewallPolicies.ts.html |here} to see how to use ListSqlFirewallPoliciesRequest. */ export interface ListSqlFirewallPoliciesRequest extends common.BaseRequest { /** * 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; /** * 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"?: ListSqlFirewallPoliciesRequest.AccessLevel; /** * A filter to return only resources that match the specified display name. * */ "displayName"?: string; /** * For list pagination. The maximum number of items to return per page in a paginated \"List\" call. For details about how pagination works, see [List Pagination](https://docs.oracle.com/iaas/en-us/iaas/Content/API/Concepts/usingapi.htm#nine). */ "limit"?: number; /** * For list pagination. The page token representing the page at which to start retrieving results. It is usually retrieved from a previous \"List\" call. For details about how pagination works, see [List Pagination](https://docs.oracle.com/iaas/en-us/iaas/Content/API/Concepts/usingapi.htm#nine). */ "page"?: string; /** * An optional filter to return only resources that match the specified OCID of the security policy resource. */ "securityPolicyId"?: string; /** * The current state of the SQL Firewall policy. */ "lifecycleState"?: model.SqlFirewallPolicyLifecycleState; /** * An optional filter to return only resources that match the specified OCID of the SQL Firewall policy resource. */ "sqlFirewallPolicyId"?: string; /** * A filter to return only items that match the specified user name. */ "dbUserName"?: string; /** * An optional filter to return only resources that match the specified violation action. */ "violationAction"?: ListSqlFirewallPoliciesRequest.ViolationAction; /** * 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"?: Date; /** * Search for resources that were created before a specific date. * Specifying this parameter corresponding {@code 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"?: Date; /** * The sort order to use, either ascending (ASC) or descending (DESC). */ "sortOrder"?: ListSqlFirewallPoliciesRequest.SortOrder; /** * The field used for sorting. Only one sorting order (sortOrder) can be specified. * The default order for TIMECREATED is descending. The default order for DISPLAYNAME is ascending. * The DISPLAYNAME sort order is case sensitive. * */ "sortBy"?: ListSqlFirewallPoliciesRequest.SortBy; /** * Unique identifier for the request. */ "opcRequestId"?: string; } export declare namespace ListSqlFirewallPoliciesRequest { enum AccessLevel { Restricted = "RESTRICTED", Accessible = "ACCESSIBLE" } enum ViolationAction { Block = "block", Observe = "observe" } enum SortOrder { Asc = "ASC", Desc = "DESC" } enum SortBy { Timecreated = "TIMECREATED", Displayname = "DISPLAYNAME" } }