You can grant only execute privilege on a procedure to specific users.
Prerequisites
To grant privileges on a stored procedure in Java (SPJ) on a schema, log in as:
The owner of the schema that contains the procedure.
The owner of the SPJ.
A user with grant privileges.
The Security Administrator.
The SUPER.SUPER user if the Security Administrator group is empty.
Procedure
Log on to the NonStop SQL/MX Database Manager.
To grant privilege on a procedure, you must be the owner of the procedure, the security administrator, a user with grant privileges, or log in as
SUPER.SUPER.
In the navigation tree, navigate to the
Schemas folder by expanding
Database > My Systems > Catalogs > Schemas.
Expand
Procedures folder (left pane) and select the procedure on which you want to revoke privileges.
Right-click and select
Grant/Revoke Privileges.
The Grant/Revoke Privileges options appear in the right pane. The
Grant option is selected by default.
Grant/Revoke Privileges
In the
Grantee section, select
Public to grant privileges to all users in the system.
Or, select
Specified Users to grant privileges to specific users in the system.
If the
Specified Users
option is selected, then 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 only the execute privilege can be granted on a procedure.
Optional. Select
By User and select the user name in the corresponding drop-down menu to grant privileges on behalf of another user.
Optional. Select
With Grant Option to grant the privileges and allow the grantees to grant the privileges to other users.
