Displaying information related to procedure privileges
To display information related to the procedure privileges:
Procedure
- In the navigation tree, select the procedure.
-
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
andSYSTEM
. -
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.
-