Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace ListSqlFirewallPoliciesRequest

example

Click here to see how to use ListSqlFirewallPoliciesRequest.

Properties

Optional accessLevel

accessLevel: AccessLevel

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.

compartmentId

compartmentId: string

A filter to return only resources that match the specified compartment OCID.

Optional compartmentIdInSubtree

compartmentIdInSubtree: undefined | false | true

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.

Optional dbUserName

dbUserName: undefined | string

A filter to return only items that match the specified user name.

Optional displayName

displayName: undefined | string

A filter to return only resources that match the specified display name.

Optional lifecycleState

lifecycleState: model.SqlFirewallPolicyLifecycleState

The current state of the SQL Firewall policy.

Optional limit

limit: undefined | number

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.

Optional opcRequestId

opcRequestId: undefined | string

Unique identifier for the request.

Optional page

page: undefined | string

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.

Optional retryConfiguration

retryConfiguration: RetryConfiguration

RetryConfiguration to be used for the request NOTE : Retries are not supported for requests that have binary or stream bodies this also affects UploadManager operations For all requests with binary/stream bodies, retry attempts are not made

Optional securityPolicyId

securityPolicyId: undefined | string

An optional filter to return only resources that match the specified OCID of the security policy resource.

Optional sortBy

sortBy: SortBy

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.

Optional sortOrder

sortOrder: SortOrder

The sort order to use, either ascending (ASC) or descending (DESC).

Optional sqlFirewallPolicyId

sqlFirewallPolicyId: undefined | string

An optional filter to return only resources that match the specified OCID of the SQL Firewall policy resource.

Optional timeCreatedGreaterThanOrEqualTo

timeCreatedGreaterThanOrEqualTo: Date

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

Optional timeCreatedLessThan

timeCreatedLessThan: 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

Optional violationAction

violationAction: ViolationAction

An optional filter to return only resources that match the specified violation action.