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-5
Revoking Privileges on an SPJ
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
behalf of the SPJ owner, revokes the WITH GRANT OPTION privilege from the HR
director of North America:
The database administrator, acting on behalf of the grantor of the privilege, can also
revoke the EXECUTE privilege from any user with this privilege and from any
dependent privileges by using the CASCADE option. In this example, the database
administrator, acting on behalf of the SPJ owner, revokes the EXECUTE privilege from
VST014.vsd
REVOKE GRANT OPTION FOR EXECUTE
ON PROCEDURE samdbcat.persnl.adjustsalary
FROM "HR.MGRNA";
Database Administrator
super ID
WITH GRANT OPTION
EXECUTE
HR Director Europe
HR.MGREU
WITH GRANT OPTION
EXECUTE
HR Director North America
HR.MGRNA
WITH GRANT OPTION
EXECUTE
Manager Marketing Dept.
MKG.RAYMOND
Manager Research Dept.
RD.MCKAY
EXECUTE
Manager Corporate Dept.
CORP.GREEN
EXECUTE