With ansi_permissions set to On, the SQL/2008 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.