Restricting Snapshot Versioning

Use the ALLOW_SNAPSHOT_VERSIONING database option to restrict the versioning allowed in the database to Table-level, Row-level, or any (no restriction). ALLOW_SNAPSHOT_VERSIONING can be set at the database (PUBLIC) level only. You cannot set it at the connection level, or user level.

Prerequisites

If setting to Row-level, the SAP Sybase IQ server has a simplex database.
Requires the SET ANY SYSTEM OPTION system privilege.

Task

Use the SET OPTION command to set the option at the PUBLIC level. SET TEMPORARY OPTION... and SET OPTION <username>... are not allowed.

Restrict the type of versioning allowed in the database to either Table-level only, or Row-level only.

Restriction	Option
Table-level only	set PUBLIC option ALLOW_SNAPSHOT_VERSIONING = 'Table-level'
Row-level only	set PUBLIC option ALLOW_SNAPSHOT_VERSIONING = 'Row-level'

Setting the option to 'Table-level' prevents RLV access to any tables in the database, effectively turning off the RLV store.

To remove the versioning restriction from the database, set the option to 'any.'

Restriction	Option
No restriction	set PUBLIC option ALLOW_SNAPSHOT_VERSIONING = 'any'