This tab has the following components:
Permissions list Shows all tables the user has permissions on, and the user who owns each table. You can click the fields for each table to grant or revoke permissions; double-clicking (so that a checkmark and two + signs appear) gives the user grant options for the permission.
Show Select what type of object appears in the Permissions list:
Tables All tables the user has permissions on.
Views All views the user has permissions on.
Procedures & functions All procedures and functions the user has permissions on. You can only grant Execute permissions for procedures and functions.
Sequence generators All sequence generators the user has permissions on. You can only grant Usage permissions for sequence generators. See Using a sequence to generate unique values.
Dbspaces All dbspaces the user has permissions on. You can only grant Create permissions for dbspaces. See Permissions on dbspaces.
The following lists the possible permissions that the consolidated user can have:
S: Select Permission to look at information in a table or view.
I: Insert Permission to insert rows into a table or view.
D: Delete Permission to delete rows from a table or view.
U: Update Permission to update rows in a table or view. This can also granted on a set of columns in a table or view.
A: Alter Permission to alter the structure of a table or create a trigger on a table.
R: References Permission to create indexes on a table and to create foreign keys that reference a table.
Check++ Grant with grant option.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|