Page 257 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Database Management Systems/Managing Database

Notes You must belong to the User Administrator role to add users to or remove users from the Data
Administrator role. Before you can add a user to any Planning Server role, the user must first be
added to Planning Server from the Users page.

To add a user to the Data Administrator role
1. On the Data Administrator Role page, select the scope of the role.
To add a user who has application scope permissions, under Data Administrator Role:
Applications, select the appropriate application.

To add a user who has model-site scope permissions, under Data Administrator Role:
Model Sites, select the appropriate application in the drop-down list, and then select the
appropriate model site.
2. Click Add/Remove Users: The Add or Remove Users: Data Administrator Role dialog
box opens.

3. In the text box next to the Add button, type the user ID of the person whom you want to
add to the role. The user ID must be entered in the domain\user name format.
4. Click Add.
5. When you are finished adding users, click Close.

To remove a user from the Data Administrator role
1. On the Data Administrator Role page, select the scope of the role.
To remove a user who has application scope permissions, under Data Administrator Role:
Applications, select the appropriate application.

To remove a user who has model-site scope permissions, under Data Administrator Role:
Model Sites, select the appropriate application in the drop-down list, and then select the
appropriate model site.

2. Click Add/Remove Users. The Add or Remove Users: Data Administrator Role dialog
box opens.
3. Select the check box next to the user who you want to remove from the role.
4. Click Remove.

5. Click Close.
Data administrators view data from the business perspective and must have an understanding
of the business to be truly effective. Their expertise allows them to define, describe, organize
and categorize data. DAs build models of the data that are a based upon data entity relationships
and the business rules that govern them. Data administrators provide the framework that allows
disparate business units within an organization to share timely and accurate data. Because Data
Administration maps the business rules into constraints that can be enforced by the database
and turns raw data into information stored in tables, the Data Administrator acts as the
intermediary between the business and Database Administration units.

14.4 Accessing Database through Web

Creating a Web Database Application

How do we create a web database? Well, we would like to demonstrate this with the help of a
very simple example. To implement the example, we use Active Sever Pages (ASP), which is one
of the old popular technologies with the backend as Ms-Access. ASP is a very easy technology to

250 LOVELY PROFESSIONAL UNIVERSITY