Setting Object Permissions for Roles

Use object access permissions to regulate the use of specific commands that access specific database objects.

1. In the Perspective Resources view, select the servers on which the roles have been defined, and select Administration Console.
2. Select ASE Servers > Security > Roles.
3. Select one or more roles on which to set object permissions, then select Properties .
4. Select Object Permissions.
5. (Optional) To view the current permission for an object, click on the drop-down menu and select the object type.
6. To grant permissions, select a database from the drop-down menus and click Grant.
   1. Select the object type to which to grant access and click Objects and Options.
   2. Select the specific object from the columns list and click Permissions.
   3. Select the type of access permissions to grant.
7. To revoke command permissions from the selected roles, select an object and click Revoke.
   • To revoke all permissions from the selected object type, click Revoke all permission.
   • To revoke individual permission access type, click the checked cells under each permission type.