Sybase Adaptive Server Anywhere - Page 189

Chapter 5 Database Options
171
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.
ANSI_UPDATE_CONSTRAINTS option
Controls the range of updates that are permitted.
OFF, CURSORS, STRICT
CURSORS in new databases.
OFF in databases created before version 7.0.
Adaptive Server Anywhere provides several extensions that allow updates
which are not permitted by the ANSI SQL standard. These extensions
provide powerful, efficient mechanisms for performing updates. However, in
some cases, they cause behavior that is not intuitive. This behavior can
produce anomalies such as lost updates if the user application is not designed
to expect the behavior of these extensions.
The ANSI_UPDATE_CONSTRAINTS option controls whether updates are
restricted to those permitted by the SQL/92 standard.
If the option is set to STRICT, the following updates are prevented:
♦ Updates of cursors containing JOINS
Function
Allowed values
Default
Description