Granting Execute Permission on a Stored Procedure

Grant execute permission on stored procedures.

  1. In the left pane of the Administration Console, expand ASE Servers > Compiled Objects, then select Stored Procedures.
  2. Click the Name field of the 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.