Displaying information related to table privileges
To display the information related to the table privileges:
Procedure
- Select a table in the left pane.
-
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
andSYSTEM
. -
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 .
-