HP System Dictionary/XL General Reference Manual Vol 1 (32256-90004)

7- 109
hpsql-auth-name-type to indicate authorization group or user, and with the attributes hpsql-connect-auth,
hpsql-dba-auth and hpsql-resource-auth to define the HP SQL special authorities granted an
authorization group or user (an HP SQL GRANT). To fully define a ’user’ HPSQL-AUTH-NAME entity use
the relationship type HPSQL-AUTH-NAME contains USER MPE-ACCOUNT (3-way) to define the user
and account that the ’user’ is made up of.
The relationship HPSQL-AUTH-NAME contains HPSQL-AUTH-NAME defines the authorization groups
and users that belong to an authorization group.
Owner
HP SQL tables, views, modules and authorization groups are owned by either an authorization group or a
user. Relationship HPSQL-AUTH-NAME owns HPSQL-TABLE defines the owner of an HP SQL table.
Relationship HPSQL-AUTH-NAME owns HPSQL-VIEW defines the owner of an HP SQL view.
Relationship HPSQL-AUTH-NAME owns MODULE defines the owner of a module. Relationship HPSQL-
AUTH-NAME owns HPSQL-AUTH-NAME defines the owner of an HP SQL authorization group.
Grants
Privileges can be granted to a user or an authorization group regarding access to tables, views and
modules.
Relationship type HPSQL-AUTH-NAME accesses HPSQL-TABLE establishes that the user or
authorization group has access to an HP SQL table. Relationship type HPSQL-AUTH-NAME accesses
HPSQL-VIEW establishes that the user or authorization group has access to an HP SQL view. Both of
these relationship types have the attributes hpsql-alter-auth, hpsql-delete-auth, hpsql-index-auth, hpsql-
insert-auth, hpsql-select-auth and hpsql-update-auth to define the authorities the user or authorization
group has to the table or view.
Relationship type HPSQL-AUTH-NAME accesses MODULE establishes that the user or authorization
group has the authority to run the module.
The authority to update a column within a table or view can be granted to a user or an authorization
group. Relationship type HPSQL-AUTH-NAME accesses ELEMENT HPSQL-TABLE (3-way) establishes
that a user or authorization group has update authority on a column within the specified table.
Relationship type HPSQL-AUTH-NAME accesses ELEMENT HPSQL-VIEW (3-way) establishes that a
user or authorization group has update authority on a column within the specified view.
HP SQL has a special category of user called PUBLIC. To grant privileges to the PUBLIC, create an hpsql-
auth-name called PUBLIC and create any of the ’accesses’ relationships listed above that are needed to
define what authorities the PUBLIC has been granted. For example, the authorities granted the PUBLIC
to table TABLE-ONE are defined by the relationship hpsql-auth-name accesses hpsql-table where the
hpsql-auth-name entity is PUBLIC and the hpsql-table entity is TABLE-ONE with the HP SQL
authorities attributes set to define which authorities the PUBLIC has to TABLE-ONE.
DBEnvironment
An HP SQL DBEnvironment is an HPDBENVIRONMENT entity. The HPDBENVIRONMENT contains
HPSQL-TABLE relationship type defines the tables in the HP SQL DBEnvironment. The
HPDBENVIRONMENT contains HPSQL-VIEW relationship type defines the views in the HP SQL
DBEnvironment. The HPDBENVIRONMENT contains HPSQL-AUTH-NAME relationship type defines
the authorization groups in the HP SQL DBEnvironment. The HPDBENVIRONMENT contains HPDBE-
FILESET relationship type defines the DBEFileSets in the HP SQL DBEnvironment. The
HPDBENVIRONMENT contains HPDBE-LOGFILE relationship type defines the logfiles used in the HP
SQL DBEnvironment. The HPDBE-LOGFILE contains FILE relationship type defines the system file by