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

Viewing information related to view privileges
To view information related to the view privileges:
1.
In the navigation tree, select the view.
2. In the right pane, click Privileges.
The following details related to the view privileges appear:
•
Grantee: — The name of the user whose privilege is described.
•
Grantor: — The name of the user who granted the privileges or 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 values displayed in
this column are schema, object, and column.
◦ Schema: — This attribute indicates that permissions have been 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 a list of granted
privileges that are separated by a comma. DDL and DML privileges are grouped
accordingly. For the list of privileges, see the HP NonStop SQL/MX Release 3.2 Reference
Manual.
Viewing procedures and their properties
To view the schema procedures 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 Procedures folder appears.
Viewing procedures and their properties 67