Neoview Guide to Stored Procedures in Java (R2.5)

ON PROCEDURE sales.monthlyorders
FROM PUBLIC;
REVOKE SELECT
ON TABLE sales.orders
FROM PUBLIC;
?SECTION RevokePersnlProcs
REVOKE GRANT OPTION FOR EXECUTE
ON PROCEDURE persnl.adjustsalary
FROM "ROLE.PAYROLLA", "ROLE.PAYROLLB"
CASCADE;
REVOKE EXECUTE
ON PROCEDURE persnl.adjustsalary
FROM "ROLE.PAYROLLA", "ROLE.PAYROLLB"
CASCADE;
REVOKE SELECT, UPDATE(salary)
ON TABLE persnl.employee
FROM "ROLE.PAYROLLA", "ROLE.PAYROLLB"
CASCADE;
To revoke privileges on the SPJs, run the script file in the NCI interface:
obey c:\revokeprocs.sql (RevokeSalesProcs)
50 Granting Privileges for Executing SPJs