Attribute

ReadOnly (RO)

Purpose

Specifies whether the connection has read-only access to the data source.

Valid Values

0 | 1

Behavior

If set to 1 (Enabled), the connection has read-only access. The following commands are the only commands that you can use when a connection is read-only:

  • Explain Plan
  • Select (except Select Into)
  • Set Schema

The driver returns an error if any other command is executed.

If set to 0 (Disabled), the connection is opened for read/write access, and you can use all commands supported by the product.
CAUTION: Before disabling the Read Only option, verify that all values in the primary key column are unique. Executing write operations against data with duplicate primary keys can produce unpredictable and undesired results.

Default

1 (Enabled)

GUI Tab

Advanced tab