Skip Headers
Oracle® Database 2 Day DBA
11g Release 1 (11.1)

Part Number B28301-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

Creating Database Control Administrative Users

When you log in to Oracle Enterprise Manager Database Control (Database Control) using the SYS, SYSTEM, or SYSMAN user accounts, you are logging 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. Examples of Database Control administration tasks include the following:

You can create Database Control administrative users who have enough privileges to administer Database Control itself, but lack the high-level database administration privileges of the SYS and SYSTEM users. This enables you to assign the minimum privileges required for other Database Control administrators to do their jobs, which is a best practice for database security. You can also create a Database Control administrative account for yourself, thus avoiding logging in as SYS or SYSTEM until you must perform database administration tasks.

Using the following procedure, you can assign Database Control administrative privileges to an existing database user or create a new Database Control administrative user. When you create a new Database Control administrative user, a user account is created for that user for the database. You must then 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.

    Description of em_admin_create.gif follows
    Description of the illustration em_admin_create.gif

  3. Click Create.

    The Create Administrator: Properties page appears.

    Description of em_admin_create_properties.gif follows
    Description of the illustration em_admin_create_properties.gif

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

  5. In the Password and Confirm Password fields, enter a user password.

    If you are creating a new user, assign a password. If you are selecting an existing user, enter any text in the password fields. The text is ignored, and the password for the user is not changed.

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

    See "Setting Up Direct Alert Notification" for more information.

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

  8. Click Finish to create the new administrative user.

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