Granting Execute Permission on an Extended Stored Procedure

Grant execute permission on extended stored procedures.

  1. In the left pane of the Administration Console, expand ASE Servers > Compiled Objects, then select Extended Stored Procedures.
  2. Click the Name field of the extended stored procedure, then click the drop-down arrow and select Properties.
  3. In the left pane, click Permissions.
  4. Click Grant to grant access permissions for the selected object.
  5. On the Welcome screen, select the type of grantee:
    • Users
    • Groups
    • Roles
  6. On the Grantee screen, select one or more grantees.
  7. Select Execute.
  8. Choose With grant option to allow the grantee to further grant permissions to other users.
  9. (Optional) Click Summary to verify your selected options.