Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Managing User IDs and Permissions » Managing individual user IDs and permissions

Granting permissions on tables Next Page

Granting permissions on views

Setting permissions on views is similar to setting them on tables.

For more information about the SQL statements involved, see Granting permissions on tables.

A user may perform an operation through a view if one or more of the following are true:

UPDATE permissions can be granted on an entire view or on individual columns within a view.

To grant permissions on views (Sybase Central)
  1. Connect to the database.

  2. Open the Views folder for that database.

  3. Select a view and then choose File > Properties.

  4. On the Permissions tab of the View property sheet, configure the permissions for the view:


You can also assign permissions from the User or Group property sheet. To assign permissions to many users and groups at once, use the View property sheet. To assign permissions to many views at once, use the User or Group property sheet.

See also