Displaying information related to table privileges

To display the information related to the table privileges:

Procedure

  1. Select a table in the left pane.
  2. In the right pane, select Privileges. The following details related to the table privileges appear:
    • Grantee: The authorization ID of the user whose privilege is described.

    • Grantor: The authorization ID of the user who granted the privileges or the special SQL user names PUBLIC and SYSTEM.

    • With Grant: The property indicates whether the user has grant privileges.

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

      • Schema: Indicates that permissions are applied to the schema.

      • Object: Indicates that permissions were applied directly to the object whose permissions are being displayed.

      • Column: 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: Describes the privilege of the user. The value is a list of granted privileges that are separated by a comma. DDL and DML privileges are grouped accordingly. For the list of privileges, see

      HPE NonStop SQL/MX Release 3.4 Reference Manual .