Granting or Revoking Permissions on a Function

Grant or revoke permission to execute a function on a Sybase IQ server.

Prerequisites

Authenticate with Sybase IQ using an account that:

If you do not have authority to modify permissions on this function, Sybase Control Center displays the Permissions page in read-only mode.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane of the Administration Console, expand IQ Servers > Other Objects and select Functions.
In the right pane, select a function to modify.
Click the drop-down arrow that appears next to the function name and select Properties.
In the left pane of the properties dialog, click Permission.
To assign permissions:
1. Click Grant.
2. Select users and groups from the list and click OK.
To cancel permissions, select a name from the permissions list and click Revoke.
Click Apply to save your changes and keep editing, or click OK to save and close the properties dialog.