Creating Database Control Administrative Users

Create : Database Control Administrative Users

The SYS, SYSTEM, or SYSMAN user accounts, log in as the Database Control super user. These are the only accounts that are automatically granted the roles and privileges required to administer Database Control itself.

Database Control administration tasks :

Creating other Database Control administrators.

Configuring e-mail and other notification methods.

Setting alert thresholds for database metrics, such as tablespace space usage percentage exceeded or SQL response time exceeded.

Selecting database policies to apply, so that Database Control can show alerts if a policy is violated.

Defining blackouts, which are time periods in which database monitoring is suspended so that maintenance operations do not skew monitoring data or generate needless alerts.


Decide which system privileges, object privileges, or roles to grant the user, if any, to perform database administration tasks.

To create a Database Control administrative user:

1.On any Database Control page, at the top of the page, click Setup.
The Enterprise Manager Configuration page appears, showing the Overview of Setup page.

2.In the left navigation bar, click Administrators.
The Administrators page appears.




3. Click Create.
The Create Administrator: Properties page appears.









4. In the Name field, enter the name of an existing database user, or click the flashlight icon next to the field and select an existing database user.

5. Enter one or more e-mail addresses for this administrator only if you plan to set up e-mail notifications for the database.

6. Click Review to view a page that summarizes the information that you entered.

7.Click Finish to configure the database user as a Database Control administrative user.

The Administrators page appears, showing the new administrator in the list.