Revoking privileges on a procedure

You can revoke only execute privilege on a procedure from specific users.

Procedure

  1. Log on to the NonStop SQL/MX Database Manager.

    To revoke privilege on a procedure, you must be the security administrator, a user with grant privileges, or log in as SUPER.SUPER user if the Security Administrator group is empty.

  2. In the navigation tree, navigate to Schemas folder by expanding Database > My Systems > Catalogs > Schemas.
  3. Expand Procedures folder (left pane) and select the procedure on which you want to revoke privileges.
  4. Right-click and select Grant/Revoke Privileges.

    The grant/revoke privileges options appear in the right pane.

  5. Select Revoke option to revoke privileges.
  6. Optional. Select Grant Option For to revoke the With Grant Option for the privilege and not the privilege itself.
  7. Select Public option in Grantee section to revoke privileges from all users in the system.

    Or, select Specified Users option in Grantee section to revoke privileges from specific users in the system.

    If Specified Users option is selected, the user grid is enabled. Press Ctrl and click on the desired user names to select users.

    In the Privileges section, the Execute option is selected and disabled. This indicates that only the execute privilege can be revoked on a procedure.

  8. Optional. Select By User option and select the user name in the corresponding list to revoke privileges on behalf of another user.

    Select Cascade option to revoke dependent privilege descriptors and objects.

  9. Click Revoke.