Controls permissions checking for DELETE and UPDATE statements.
ON, OFF
ON
Option can be set at the database (PUBLIC) level only.
Requires the SET ANY SYSTEM OPTION system privilege to set this option. Takes effect immediately.
With ANSI_PERMISSIONS ON, SQL92 permission requirements for DELETE and UPDATE statements are checked. The default value is OFF in SAP ASE. This 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 table | DELETE permission on table. SELECT permission on all columns appearing in the WHERE clause. |