Revoking Function EXECUTE Permission

Remove function execute permission from users and roles.

Prerequisites
Database Version Database Object Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • PERMS ADMIN authority.
  • You own the database object.
SAP Sybase IQ 16.0 Requires one of:
  • MANAGE ANY OBJECT PRIVILEGE system privilege.
  • You own the database object.
Task
  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the Administration Console, expand IQ Servers > Compiled Objects > Functions.
  3. Select a function from the right pane and either:
    • Click the arrow to the right of the name and select Properties, or
    • From the Administration Console menu bar, select Resource > Properties.
    The Function Properties view appears.
  4. In the left pane, click Permissions.
  5. In the right pane, select a grantee, and click Revoke.
  6. Click OK.
Parent topic: Functions
Related tasks
Creating a Watcom SQL or Transact-SQL Function
Creating an External Java Function
Creating an External C/C++ Scalar or Aggregate Function
Deleting a Function
Generating Function DDL Commands
Viewing and Modifying a Function
Granting Function EXECUTE Permission
Authenticating a Login Account for a Managed Resource
Related reference
Function Privilege Summary