HP Integrity NonStop J-Series - Manual (Page 71)

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 the HP
NonStop SQL/MX Release 3.2 Reference Manual.
Viewing SQL/MP aliases and their properties
To view the SQL/MP aliases and their properties:
1.
Log on to the HP NonStop SQL/MX Database Manager.
2. Under the navigation tree pane, click Database.
MXDM displays a list of existing systems.
3. In the navigation tree, expand the contents of the system.
The list of catalogs appears.
4. Expand the contents of a catalog.
The list of schemas appears.
5. Expand the contents of a schema.
The SQL/MP Aliases folder appears.
Viewing SQL/MP aliases and their properties 71