Sybase 12.4.2 manual Granting users the right to grant permissions, 360

Managing individual user IDs and permissions

1 Connect to the database as a user with DBA authority, or as the owner of sample_table.

2 Type and execute the SQL statement:

GRANT UPDATE (column_1, column_2)

ON sample_table

TO M_Haneef

Granting user permissions on tables in Sybase Central

Table and view permissions are limited in that they apply to all the data in a table or view (except for the UPDATE permission which may be restricted). Finer tuning of user permissions can be accomplished by creating procedures that carry out actions on tables, and then granting users the permission to execute the procedure.

One way to grant a user permissions on a table in Sybase Central is as follows:

❖To grant user permission on tables in Sybase Central

1Connect to the database.

2Double-click the Tables folder for that database, to display the tables in the left panel.

3Click the Users and Groups folder, and locate the user you want to grant permissions to.

4Drag the user to the table for which you want to grant permissions.

For more information, see the Sybase Central online Help.

Granting users the right to grant permissions

	Each of the table and view permissions described in “Granting permissions on
	tables and views” can be assigned WITH GRANT OPTION. This option gives
	the right to pass on the permission to other users. This feature is discussed in
	the context of groups in “Permissions of groups”.
Example	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:
	1 Connect to the database as a user with DBA authority, or as the owner of
	sample_table:
	2 Type and execute the SQL statement:
	GRANT DELETE ON sample_table

360