SQL/MX Guide to Stored Procedures in Java (G06.24+, H06.03+)

Managing SPJs in NonStop SQL/MX
HP NonStop SQL/MX Guide to Stored Procedures in Java—523727-004
6-6
Revoking Privileges on an SPJ
the HR director of North America and from the department managers to whom the HR
director granted privileges:
For SPJs on which all users (that is, PUBLIC) have privileges, you can revoke
privileges from PUBLIC but not from one or more specific users. For example, this
statement revokes the EXECUTE privilege on the SPJ named MONTHLYORDERS
from all users (that is, PUBLIC):
REVOKE EXECUTE
ON PROCEDURE samdbcat.sales.monthlyorders
FROM PUBLIC;
VST015.vsd
REVOKE EXECUTE
ON PROCEDURE samdbcat.persnl.adjustsalary
FROM "HR.MGRNA"
CASCADE;
Database Administrator
super ID
WITH GRANT OPTION
EXECUTE
HR Director Europe
HR.MGREU
WITH GRANT OPTION
EXECUTE
Manager Marketing Dept.
MKG.RAYMOND
HR Director North America
HR.MGRNA
EXECUTE
Manager Research Dept.
RD.MCKAY
EXECUTE
Manager Corporate Dept.
CORP.GREEN
EXECUTE