Neoview SQL Reference Manual (R2.4 SP2)

Examples of GRANT EXECUTE
• The SPJ owner (or creator) grants the EXECUTE and WITH GRANT OPTION privileges on
the ADJUSTSALARY procedure to the role ROLE.HR:
GRANT EXECUTE
ON PROCEDURE persnl.adjustsalary
TO "ROLE.HR"
WITH GRANT OPTION;
• The role ROLE.HR grants the EXECUTE privilege on the ADJUSTSALARY procedure to
other roles:
GRANT EXECUTE
ON PROCEDURE persnl.adjustsalary
TO "ROLE.PAYROLL", "ROLE.FINANCE";
• The SPJ owner (or creator) grants the EXECUTE privilege on the TOTALPRICE procedure
to all roles:
GRANT EXECUTE
ON sales.totalprice
TO PUBLIC;
138 SQL Statements