HP Neoview Release 2.4 Software - Manual (Page 69)

Parameters Tab
To display the procedure parameter information:
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 Parameters tab in the right pane.
In the right pane, these attributes are displayed:
•
Name: Name of the parameter.
• Direction: The values displayed are: IN | OUT | INOUT.
IN passes data to the procedure. OUT accepts data from the procedure. This is the
default for array parameters. INOUT passes data to and accepts data from the procedure.
• SQL Data Type: Specifies an SQL data type that corresponds to the Java parameter of
the procedure Java method. For information on SQL data types, see the Neoview SQL
Reference Manual.
• Java Data Type: Specifies a mappable Java data type. For information on Java data
types, see the Neoview Stored Procedures in Java Manual.
Privileges Tab
To display the privileges for the procedure:
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 user or role whose privilege is being described.
• Grantor: The name of the user or role who granted the privileges and the special SQL
user names “PUBLIC” and “SYSTEM.”
• With Grant: Specifies an ‘X’ to indicate if the user or 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 user or 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.
Display Synonyms and Their Properties
To display the synonym names in the schema:
1. Start the HP Database Manager and log on using any user ID.
2. Click the Database area.
3. Select a system in My Active Systems in the navigation tree.
Display Synonyms and Their Properties 69