SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

G-7

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 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.

For more information, see Security on page S-11.

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 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 this

file-id, can be an SQL catalog name.

file-id

is the name of a Guardian disk file or the name of a SQL/MP table, view, index,

partition, collation, or program. The name consists of a letter followed by 1 to 7

32,255 Group manager user ID number

DP.MANAGER Typical group manager user ID

name

[ [ \node. ] [ $volume. ] subvol. ] file-id