Working on Mart › The Administrator's Tasks

The Administrator's Tasks

When you install the CA ERwin Data Modeler Workgroup Edition, the administrator role is automatically granted Administrator security status. This lets the administrator assign user permissions and perform all required maintenance or administrative tasks.

An administrator’s responsibilities can be categorized as follows:

• Create, update/convert, and initialize the mart
• Install and upgrade the software
• Delete a mart
• Develop and administer standards
• Manage user sessions
• Administer security
• Create and maintain a library structure
• Create shared reports and perform administrative reports

To perform these tasks, you must log on to your DBMS as the database owner (dbo) in Microsoft SQL Server and Sybase or the schema owner of the Oracle database that contains the mart database.

Note: For more information about creating and updating the mart, see the Implementation Guide. For more details about other administrator functions, see the Administration Guide.

More information:

Microsoft SQL Server 2005 Permissions