ansi_permissions option

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

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

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

SELECT privilege on all columns appearing in the WHERE clause