SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Introduction

HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001

1-8

Security Administrator's Group

The Security Administrator's Group (SAG) is the set of currently defined security

administrators within the domain of a SQL/MX system catalog. The set might be empty.

With Grant Option

With Grant Option (WGO) is specified by SQL:1999 and refers to the right to grant a

privilege to another user and also grant WGO with that privilege. All inherent privileges

held by the owner of an object are held WGO. The With Grant Option must be explicitly

included in a GRANT statement to convey the WGO privilege, otherwise by default, the

grantee(s) of the privilege may not grant that privilege to other users.

Owner-Derived Grant

An owner-derived grant is an access privilege conveyed to a user through a privilege

held WGO that can be traced back to the owner of an object. Owner-derived grants

include the inherent privileges held by object owners, grants from the owner to other

users, subsequent grants made by those users, and so on. The set of these grants can

be visualized as hierarchies of grants rooted in each inherent privilege of the object

owners (the owner-derived hierarchy of grants).

Derived Privilege

A derived privilege is a privilege held as a result of an owner-derived grant.

Derived WGO

Derived WGO refers to a privilege held as a result of an owner-derived grant With

Grant Option.

Security Administrator Grant

A security administrator grant is an access privilege conveyed to a user that is distinct

from an owner-derived grant and is therefore outside the owner-derived hierarchy of

grants.