Contents Index ANSI_INTEGER_OVERFLOW option [compatibility] ANSI_UPDATE_CONSTRAINTS option [compatibility]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

ANSI_PERMISSIONS option [compatibility]


Function 

Controls permissions checking for DELETE and UPDATE statements.

Allowed values 

ON, OFF

Scope 

Can be set for the PUBLIC group only. Takes effect immediately. DBA authority is required to set this option.

Default 

ON

Description 

With ANSI_PERMISSIONS ON, the SQL/92 permissions requirements for DELETE and UPDATE statements are checked. The default value is OFF in Adaptive Server Enterprise. The following table outlines the differences.

SQL Statement Permissions required with ANSI_PERMISSIONS off Permissions required with ANSI_PERMISSIONS on
UPDATE UPDATE permission on the columns where values are being set UPDATE permission on the columns where values are being set SELECT permission on all columns appearing in the WHERE clause SELECT permission on all columns on the right side of the set clause
DELETE DELETE permission on the table DELETE permission on the table SELECT permission on all columns appearing in the WHERE clause

The ANSI_PERMISSIONS option can be set only for the PUBLIC group. No private settings are allowed.


Contents Index ANSI_INTEGER_OVERFLOW option [compatibility] ANSI_UPDATE_CONSTRAINTS option [compatibility]