beautypg.com

HP Neoview Release 2.4 Software User Manual

Page 48

background image

1.

Select a Schema in the navigation tree.

2.

Click on 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 on the Privileges tab in the right pane.

The Privileges tab displays a table showing the access privileges.

Grantee: The name of a user whose privilege is being described.

Grantor: The name of the user who granted the privileges and the special SQL user
names “PUBLIC” and “SYSTEM.”

With Grant: Specifies an ‘X’ to indicate if the user 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. The value is “All Privileges” or a list of
granted privileges separated by a comma: ALTER, ALTER TABLE, CREATE, CREATE
TABLE, CREATE VIEW, DELETE, EXECUTE, INSERT, REFERENCE, SELECT, and
UPDATE.

48

Managing Database Objects