You can give a user permission to execute system procedures and functions by granting EXECUTE permission for that object.
For tables, views, and dbspaces, there are several distinct permissions you may grant to user IDs:
|ALTER||Permission to alter the structure of a table or create a trigger on a table.|
|CREATE ON||Permission to create database objects on the specified dbspace.|
|DELETE||Permission to delete rows from a table or view.|
|INSERT||Permission to insert rows into a table or view.|
|REFERENCES||Permission to create indexes on a table and to create foreign keys that reference a table.|
|SELECT||Permission to look at information in a table or view.|
|UPDATE||Permission to update rows in a table or view. This can also granted on a set of columns in a table or view.|
|ALL||All the above permissions.|
For more information about the permissions you can set on database objects, see GRANT statement.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|