HP 3000 Manuals HP 3000 Manuals
DBA Capabilities
DBA Capabilities
Information Access allows more than one DBA to run the Administrator
Utility. However, not all DBAs can perform all the Administrator
functions or have unlimited access to all data in the data dictionary.
The primary DBA has complete control of the Administrator Utility and its
functions and can delegate responsibility to one or more secondary DBAs.
Primary DBA Capabilities.
* Has full Administrator Utility capabilities
* Has unlimited access to data dictionary
* Defines certain users as secondary DBAs
* Configures users and access groups
* Configures remote systems
* Configures tables from all data sources
* Controls entries in the data dictionary that are not controlled by
a secondary DBA
* Produces reports showing all users and access groups
* Produces reports showing all data sources and their associated
tables
* Can synchronize any table in the data dictionary
* Has override power over secondary DBAs
Secondary DBA Capabilities.
* Configures users and access groups
* Controls data sources (either created by self or transferred from
another DBA)
* Configures tables from data sources they control
* Configures table and item security for tables they control
* Can give up control of a data source to the primary DBA or to
another secondary DBA
* Can synchronize tables they control
* Can list users they control
* Can list all access groups
* Produces reports showing the users and access groups they control
* Produces reports showing the data sources they control along with
their associated tables
Rules.
* The controller of an IMAGE or file table is the controller of the
data source from which the table is configured.
* To control view tables, a secondary DBA must control all of the
tables from which the view table is configured.
* View tables created from tables that are controlled by more than
one DBA can only be created and controlled by the primary DBA.
* Data sources and tables can be changed, deleted, or displayed by
the primary DBA or the controlling secondary DBA.
For descriptions of how primary DBAs and secondary DBAs perform specific
Administrator Utility functions, see the appropriate chapters in this
manual.
Assigning Secondary DBA Capabilities
Only the primary DBA can give secondary DBA capability to a user. This
is done at the Add User (AU) or Change User (CU) screens. (See "Adding a
User Definition" and "Changing a User Definition" in Chapter 7.)