You can assign each of the table and view permissions described with the WITH GRANT OPTION. This option gives the right to pass on the permission to other users.
In Sybase Central, you can specify a grant option by displaying the properties window of a user, group, or table, clicking the Permissions tab, and double-clicking the fields provided so that a check mark with two '+' signs appears.
You can only specify WITH GRANT OPTION for users. Members of groups do not inherit the WITH GRANT OPTION if it is granted to a group.
You can grant permission to M_Haneef to delete rows from the table named sample_table, and the right to pass on this permission to other users, as follows:
GRANT DELETE ON sample_table TO M_Haneef WITH GRANT OPTION;
See GRANT statement.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|