NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
G-7
Group Manager
•
The following example deletes the shadow label indexb:
43> GOAWAY indexb:S
Group Manager
A group manager is a Guardian user ID that has user number 255. By convention, a
group manager also has the user name MANAGER, but this is not required.
A group manager can act as the owner of any object or file on the local node owned by a
member of the Guardian security group to which the group manager belongs (group
number 32 or group name DP in the examples just listed). A group manager can also act
as the owner of an object or file owned by a member of the group on a remote node,
provided that the file is secured so that the owner has purge authority on remote nodes.
The group manager is said to be a “generalized owner” of such objects and files.
See Security
on page S-11 for more information.
Guardian Names
A Guardian name is a form of name used for disk files and other entities on the
Guardian operating system.
NonStop SQL/MP uses Guardian names as names for SQL tables, views, indexes,
partitions, collations, and programs. NonStop SQL/MP uses a portion of a Guardian
name (the subvolume name) as an SQL catalog name.
\node
is the name of a node on a NonStop system. The name must be preceded by a
backslash and consist of a letter followed by 1 to 6 letters or digits.
$volume
is the name of a disk volume. The name must be preceded by a dollar sign and
consist of a letter followed by 1 to 7 letters or digits.
subvol
is a subvolume name that consists of a letter followed by 1 to 7 letters or digits. A
subvolume name, optionally preceded by a node and volume name but without the
following file-id, can be an SQL catalog name.
32,255 Group manager user ID number
DP.MANAGE
R
Typical group manager user ID name
[ [ \node. ] [ $volume. ] subvol. ] file-id