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

1. Select a Schema in the navigation tree.
2. Click the Procedures tab in the right pane and select a procedure name, or open the
Procedures folder and select a procedure name in the tree.
3. Click the Privileges tab in the right pane.
The Privileges tab displays a table showing the access privileges.
• Grantee: The name of a role whose privilege is being described.
• Grantor: The name of the role that granted the privileges and the special SQL user
names “PUBLIC” and “SYSTEM.”
• With Grant: Specifies an ‘X’ to indicate if the role has grant privileges.
• Grant Level: The level at which the permissions are visible. The values displayed in
this column are: Schema, Object, or Column.
— Schema indicates permissions have been applied to the schema.
— Object indicates permissions were applied directly to the object whose permissions
are being displayed.
— Column indicates the permissions applied to the column. When an object level
privilege applies to all columns, the individual column privileges are not displayed,
otherwise the individual column level permissions are listed.
• Privileges: Describes the privilege of the role. The value is “All Privileges” or a list of
granted privileges separated by a comma. DDL and DML privileges are grouped
accordingly. For a complete list of privileges, see the GRANT SCHEMA statement
information in the Neoview SQL Reference Manual.
Using NCI to Display Procedures in a Schema
In the NCI command-line interface, use the SHOW PROCEDURES command to display the
procedures 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.
Altering an SPJ and Its Java Bytecode
Occasionally, you might need to update an SPJ or its Java bytecode. The Java bytecode includes
the SPJ's class file and any associated class files that are packaged in the SPJ JAR file. Suppose
that you want to update the Java bytecode of an SPJ without changing the class name, method
name, or Java signature of the SPJ method. In this case, you would upload a new JAR file and
44 Creating SPJs in the Neoview Database