Neoview Guide to Stored Procedures in Java (R2.3, R2.4)

obey c:\grantprocs.sql (GrantSalesProcs)
Script File for Revoking Privileges
You can use another or the same script file to revoke privileges on a series of SPJs. For example,
the script file, revokeprocs.sql, contains a series of REVOKE EXECUTE and REVOKE
statements:
?SECTION RevokeSalesProcs
REVOKE EXECUTE
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)
Using DB Admin to Grant Privileges on SPJs
1. In DB Admin, click the Database tab.
2. Open the Schemas folder, and navigate to the schema that contains the SPJs.
3. Open the schema folder, and then open the Procedures folder.
4. Click the procedure name under the Procedures folder, or click the procedure name link in
the right pane.
5. Click the Privileges tab to display the privileges assigned to the SPJ:
54 Granting Privileges for Executing SPJs