The Database painter's Design>Table Security menu allows you to control access to the current database. You use the Table Security dialog box to assign table access privileges to different users and groups.
UltraLite databases do not use owners and groups. All users have full permission to update tables, and you cannot use the procedures described in this section to grant or revoke access to tables.
Figure 16-13: Assigning privileges in the Table Security dialog box
To control access to the current database:
Select Design>Table Security from the Database painter menu
Select a user or group, or multiple users and groups, from the Groups/Users list box.
Select a table from the Tables list box.
Select the privileges you want to give the selected users or groups for the table you selected in the previous step, and click Apply.
Update privileges can be restricted to specific columns of the selected table by clicking the Update button, selecting only those columns for which you want to grant the privilege, and clicking OK.
Repeat steps 2 – 5 until you have granted all the privileges that you want to assign, then click Done.
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
