SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-147
Examples of GRANT EXECUTE
•
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;