SQL/MX 3.2 Guide to Stored Procedures in Java (H06.25+, J06.14+)

Managing SPJs in NonStop SQL/MX
HP NonStop SQL/MX Release 3.2 Guide to Stored Procedures in Java—691166-001
6-4
Revoking Privileges on an SPJ
If you own the SPJ, you can revoke the EXECUTE and WITH GRANT OPTION
privileges on the SPJ from any user to whom you granted those privileges. If you are
the super ID acting on behalf of a grantor, you can revoke the EXECUTE and WITH
GRANT OPTION privileges on the SPJ from any user to whom the grantor granted
those privileges. If you are not the owner of the SPJ or the super ID, you must have
been granted the WITH GRANT OPTION privilege to revoke privileges from other
users, and you can revoke privileges only from other users to whom you have granted
privileges.
For example, the HR director of North America can revoke the EXECUTE privilege on
ADJUSTSALARY from one or more of the department managers to whom the director
granted privileges. In this example, the HR director revokes the EXECUTE privilege
from the Marketing Department manager:
The HR director of North America cannot revoke the EXECUTE or WITH GRANT
OPTION privilege from the HR director of Europe because it was the database
administrator who granted the privileges on behalf of the SPJ owner.
The database administrator (the super ID), acting on behalf of the grantor of the
privilege, can revoke the WITH GRANT OPTION privilege on ADJUSTSALARY from
any user with this privilege. In this example, the database administrator, acting on
VST013.vsd
REVOKE EXECUTE
ON PROCEDURE samdbcat.persnl.adjustsalary
FROM "MKG.RAYMOND";
Database Administrator
super ID
WITH GRANT OPTION
EXECUTE
HR Director North America
HR.MGRNA
WITH GRANT OPTION
EXECUTE
HR Director Europe
HR.MGREU
WITH GRANT OPTION
EXECUTE
Manager Research Dept.
RD.MCKAY
EXECUTE
Manager Corporate Dept.
CORP.GREEN
EXECUTE
Manager Marketing Dept.
MKG.RAYMOND
EXECUTE