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:
Instead of the owner having permission(s) WITH GRANT OPTION on the base table(s), permission(s) may have been granted to PUBLIC. This includes SELECT permission on system tables.
UPDATE permissions can be granted on an entire view or on individual columns within a view.
You can grant permissions on disabled views. Permissions to disabled views are stored in the database and become effective when the object is enabled.
To grant permissions on views (Sybase Central)
Connect to the database as a user with DBA authority.
Right-click a view and then choose Properties.
Click the Permissions tab.
Configure the permissions for the view:
You can also assign permissions from the User Properties or Group Properties window. Use the View Properties window to assign permissions to multiple users or groups. Use the User Properties or Group Properties window to assign permissions to multiple views.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|