SQL/MX 2.x Reference Manual (H06.04+)
SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-143
Examples of GRANT EXECUTE
WITH GRANT OPTION
BY 'SYSMGT.ANDY';
The users, 'SYSMGT.BEN' and 'SYSMGT.JASON,' can then issue EXECUTE
and WITH GRANT OPTION privileges to other users on the system. They can also
execute CALL statements.
•
The user 'SYSMGT.BEN' grants EXECUTE and WITH GRANT OPTION privileges
on spj1 to user 'HR.BETTY':
GRANT EXECUTE
ON PROCEDURE samdbcat.persnl.spj1
TO 'HR.BETTY'
WITH GRANT OPTION;
•
The user 'HR.BETTY' grants EXECUTE privilege on spj1 to some users in the
HR group:
GRANT EXECUTE
ON PROCEDURE samdbcat.persnl.spj1
TO 'HR.MIKE', 'HR.JOE', 'HR.HILDE';
•
The owner of spj2 grants EXECUTE privilege on that SPJ to all users of the
system:
GRANT EXECUTE
ON samdbcat.persnl.spj2
TO PUBLIC;