Page 256 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Unit 14: Application Development and Administration

Notes

Task Discuss something about DBI.
14.3 Data Administrator’s Role and Functions

Data administrator is one who oversees the data integrity of the database. They do not create
objects and they may not have privileges to do anything other than “view” the data and report
any data discrepancies to the database administrator (one who administers the entire database).
The data administrator can check data in the tables to make sure there are no errors, can check to
see if tables that need an index have one, are all programs valid–stuff like that. The database
administrator is usually busy with fixing problems, creating tablespaces, tables, looking at
error messages. In a nutshell, the Data Administrator performs data integration tasks.
The following considerations apply to the Data Administrator’s role:
1. Users who are assigned to the Data Administrator role have unrestricted access to all
business data within their scope, even if they belong to a business role that has restricted
settings.

2. Assigning a member to the Data Administrator role does not guarantee explicit permissions
to the staging and application database to perform all necessary tasks for data integration.
For more information, see Performance Point Server Data Integration Help.
3. For security reasons, work performed by Data Administrator role members should be
carefully reviewed, because those users can browse databases. We recommend that Data
Administrator role members do not have full database permissions unless it is necessary.
4. Members of the Data Administrator role cannot create or delete applications or model
sites or manage role membership.
On the Data Administrator Role page, users who currently belong to the role are listed in the
User ID column next to the appropriate application or model site. Except for the Global
Administrator role, which has system-wide scope, Planning Server administrator roles have
either an application scope or a model-site scope. Application scope permissions apply for all
model sites in an application. Model-site scope permissions apply only for the specific model
site.

LOVELY PROFESSIONAL UNIVERSITY 249