Displaying information related to procedure privileges

To display information related to the procedure privileges:

Procedure

  1. In the navigation tree, select the procedure.
  2. In the right pane, click Privileges.

    The following details related to the procedure privileges appear:

    • Grantee — The name of the user whose privilege is described.

    • Grantor — The name of the user who granted the privileges and the special SQL user names PUBLIC and SYSTEM.

    • With Grant — This attribute indicates whether the user has grant privileges.

    • Grant Level — The level at which the permissions are visible. The column displays the schema, object, and column values.

      • Schema — This attribute indicates that permissions are applied to the schema.

      • Object — This attribute indicates that permissions were applied directly to the object whose permissions are displayed.

      • Column — This attribute indicates that permissions are applied to the column. When an object-level privilege applies to all columns, the individual column privileges do not appear. Otherwise, the individual column permissions appear.

    • Privileges — This attribute describes the privilege of the user. The value is Execute. DDL and DML privileges are grouped accordingly. For the list of privileges, see HPE NonStop SQL/MX Release 3.4 Reference Manual.