Filter
Top Products
Managing individual user IDs and permissions
360
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:
❖ To grant user permission on tables in Sybase Central
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.
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