For tables and views you can grant a user the permission to grant the same permission to other users. You use the WITH GRANT OPTION with the GRANT statement to grant users this permission. The permission to grant the same permission to other users is not inherited by members of a group.
Members of a group can inherit only the following permissions for the group they belong to:
Connect to the database as a user with DBA authority or as the user who owns the table or view.
Execute a GRANT statement with the WITH GRANT OPTION to assign the permission. See GRANT statement.
GRANT DELETE ON sample_table TO M_Haneef WITH GRANT OPTION;
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|