SQL/MX 3.2.1 Guide to Stored Procedures in Java (H06.26+, J06.15+)

For SPJs on which all users (that is, PUBLIC) have privileges, you can revoke privileges from PUBLIC
but not from one or more specific users. For example, this statement revokes the EXECUTE privilege
on the SPJ named MONTHLYORDERS from all users (that is, PUBLIC):
REVOKE EXECUTE
ON PROCEDURE samdbcat.sales.monthlyorders
FROM PUBLIC;
Displaying Information About SPJs
To manage SPJs in NonStop SQL/MX, you might need to gather information about the SPJs that
are already registered in the database. For more information, see:
• Listing the SPJs in a Catalog (page 88)
• Showing Privileges on the SPJs (page 89)
• Showing the Procedure Labels of All SPJs in a Catalog (page 92)
• Showing the Syntax of an SPJ (page 92)
The first three topics suggest querying SQL/MX system metadata. For information about system
metadata tables, see the SQL/MX Reference Manual.
Listing the SPJs in a Catalog
To display the names of all SPJs in a user catalog of the database, query the OBJECTS, SCHEMATA,
and CATSYS system metadata tables and store the results in a log file, if desired.
For example:
1. In an MXCI session, enter the LOG command so that MXCI writes the output of the query to
a log file:
88 Managing SPJs in NonStop SQL/MX