HP Neoview Release 2.5 Software - Manual (Page 87)

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.
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 Systems in the navigation tree.
4. Select a Schema in the navigation tree.
5. In the navigation tree pane, expand the Synonyms folder, and select a synonym.
Display Synonyms and Their Properties 87