Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

ansi_permissions option

Controls privileges checking for DELETE and UPDATE statements.

Allowed values

On, Off

Default

On

Scope
  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY SYSTEM OPTION No No
Allowed to set temporarily? Yes, with SET ANY SYSTEM OPTION No No
Remarks

With ansi_permissions set to On, the ANSI/ISO SQL Standard privilege 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 Privileges required with ansi_permissions off Privileges required with ansi_permissions on
UPDATE UPDATE privilege on the columns where values are being set

UPDATE privilege on the columns where values are being set

SELECT privilege on all columns appearing in the WHERE clause

SELECT privilege on all columns on the right side of the SET clause

DELETE DELETE privilege on the table

DELETE privilege on the table

SELECT privilege on all columns appearing in the WHERE clause