SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Introduction
HP NonStop SQL/MX Reference Manual—544517-008
1-6
The Super ID
The PUBLIC identifier specifies all users in the node at present and future times and
can be used in the GRANT and REVOKE statements. SYSTEM cannot be specified in
GRANT and REVOKE statements.
The Super ID
In SQL:1999, the creator of an object is the owner of the object. In addition, NonStop
SQL/MX enables the super ID, corresponding to Guardian user-id (255,255), to act as
the owner of any object on a given node.
The super ID can create objects in a schema owned by any user. However, when the
super ID creates an object in a schema owned by some other user, the actual owner of
that object is that user, not the super ID. In addition to creating objects, the super ID
can grant or revoke privileges on objects on behalf of users who have the privilege of
performing this grant or revoke action.
The super ID can perform DDL operations on any object on behalf of the object’s
owner.
Guardian User ID
Each user authorized to log on to a node is identified by a Guardian user ID that
consists of a group and user identification. The user ID has one of these forms:
group_number,user_number or
group_name.user_name
Guardian Super ID
Each node has one special user ID called the super ID that has Guardian group 255
and user number 255. The super ID has one of these forms:
255,255 or
SUPER.SUPER
The super ID can act as the owner of any object or file on the node.