ansi_permissions option

On, Off

On

Can be set for the PUBLIC group only. Takes effect immediately. DBA authority required.

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

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

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

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.

ansi_permissions option

Allowed values

Default

Scope

Remarks

See also