Sybase 12.4.2 Manuale Utente

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

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.

Granting user 
permissions on tables 
in Sybase Central

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

❖

1

Connect to the database.

2

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

3

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

4

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

For more information, see the Sybase Central online Help.

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