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

8. Click the Privileges tab to display the privileges assigned to the SPJ:
To change the privileges, see “Using DB Admin to Grant Privileges on SPJs” (page 54) or
“Using DB Admin to Revoke Privileges on SPJs” (page 57).
Using NCI to Display SPJs in a Schema
In the NCI command-line interface, use the SHOW PROCEDURES command to display the SPJs
in a schema. For example, this SHOW PROCEDURES command displays a list of the procedures
in the SALES schema:
SQL>set schema sales;
--- SQL operation complete.
SQL>show procedures
PROCEDURE NAMES
--------------------------------------------------------------------------------
DAILYORDERS LOWERPRICE MONTHLYORDERS ORDERSUMMARY PARTDATA TOTAL
PRICE
SQL>
You can also use a wild-card pattern to search for a particular procedure. For example, this
SHOW PROCEDURES command displays all the procedures in the SALES schema that have
price in their names:
SQL>show procedures %price
PROCEDURE NAMES
--------------------------------------------------------------------------------
LOWERPRICE TOTALPRICE
SQL>
For more information about NCI, see the Neoview Command Interface (NCI) Guide.
Dropping SPJs
1. In DB Admin, click the Database tab.
Dropping SPJs 49