Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace SqlCollection

The resource represents SQL collection for a specific database user in a target. SqlCollection encapsulates the SQL commands issued in the user\u2019s database sessions, and its execution context.

Properties

compartmentId

compartmentId: string

The OCID of the compartment containing the SQL collection.

dbUserName

dbUserName: string

The database user name.

Optional definedTags

definedTags: undefined | object

Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags

Example: {@code {\"Operations\": {\"CostCenter\": \"42\"}}}

Optional description

description: undefined | string

The description of the SQL collection.

displayName

displayName: string

The display name of the SQL collection.

Optional freeformTags

freeformTags: undefined | object

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: {@code {\"Department\": \"Finance\"}}

id

id: string

The OCID of the SQL collection.

Optional lifecycleDetails

lifecycleDetails: undefined | string

Details about the current state of the SQL collection in Data Safe.

lifecycleState

The current state of the SQL collection.

Optional sqlLevel

sqlLevel: SqlLevel

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.

status

status: Status

Specifies if the status of the SqlCollection. Enabled indicates that the collecting is in progress.

Optional systemTags

systemTags: undefined | object

System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {@code {"orcl-cloud": {"free-tier-retained": "true"}}}

targetId

targetId: string

The OCID of the target corresponding to the security policy deployment.

timeCreated

timeCreated: Date

The time that the SQL collection was created, in the format defined by RFC3339.

Optional timeLastStarted

timeLastStarted: Date

The timestamp of the most recent SqlCollection start operation, in the format defined by RFC3339.

Optional timeLastStopped

timeLastStopped: Date

The timestamp of the most recent SqlCollection stop operation, in the format defined by RFC3339.

Optional timeUpdated

timeUpdated: Date

The last date and time the SQL collection was updated, in the format defined by RFC3339.

Functions

getDeserializedJsonObj

getJsonObj