Documentation Home
MySQL Enterprise Monitor 2.3 Manual
Related Documentation Download this Manual
PDF (US Ltr) - 4.0Mb
PDF (A4) - 4.0Mb
EPUB - 3.2Mb
HTML Download (TGZ) - 3.1Mb
HTML Download (Zip) - 3.1Mb

2.8.4 Managing Users

The Manage Users panel lets you create, delete and manage individual users that have access to MySQL Enterprise Service Manager.

Figure 2.24 MySQL Enterprise Monitor User Interface: Manage Users

MySQL Enterprise Monitor User Interface: Manage Users

To log in to the Dashboard a user account is required. There are four types of users with varying privileges:

  • manager role

    A user with the role of manager can perform all operations within MySQL Enterprise Service Manager, including changing the server configuration, adding and removing users, and viewing query analyzer and other data.

  • dba role

    Users with the dba role should be database administrators who are using MySQL Enterprise Monitor to monitor servers and queries. They have a similar set of privileges to those with the manager, except that they cannot do the following:

    • Cannot add/remove or change users.

    • Cannot change the My Oracle Support credentials used to communicate with the My Oracle Support website.

    • Cannot change the HTTP proxy settings.

    • Cannot change the Query Analyzer settings.

    • Cannot update the Advisor bundle.

    • Cannot change the LDAP authentication preferences.

    In addition to these limitations, you can control for each user with the dba role whether:

    • View Query Analyzer tab: Limits whether the user can see the Query Analyzer tab and its contents.

    • View action (example) queries: Limits whether the user can see the values within queries shown within the query analyzer.

    The setting for these abilities is provided when you select the dba role for a user.

  • read-only

    The read-only role is identical to the dba role, but is unable to make any changes to the configuration of MySQL Enterprise Monitor, although they can view the current settings.

  • agent

    The agent role is reserved for all users that you want to have access and ability to send agent information. You can use this if you want to provide individual logins for each agent.

The Administrator defined during installation as having the root role is unique; this user cannot be deleted.

If you are logged in as an Administrator, you can add a new user by choosing the Manage Users link from the Settings tab. To create a user click the create user button, select a role for the user, and enter a user name and password.

When a new user first logs in, a dialog box opens requesting time zone and locale information. To change this information later, use the User Preferences tab. For more information, see Section 2.8.2, “User Preferences”.

If you installed the Advisors through the Dashboard, you have probably configured the settings for the root role user already. (See Section 2.8.1, “Global Settings” and following for more information about this topic.)


To receive support-related updates, configure the My Oracle Support credentials for at least one user. These settings were set up on the first login to the Dashboard. For information on changing these settings, see Section 2.8.1, “Global Settings”.

To edit an existing user's information, select the Manage Users link, then select the user to edit. Make your desired changes in the fields provided, then save the changes.

Users can be authenticated either using an internal authentication system, which stores the user, password and role information within MySQL Enterprise Monitor, or you can opt to use an external LDAP service. To use the LDAP service, you still create each user, and then select the Authenticate this user using LDAP checkbox within the Edit User window. The username entered is authenticated against the configured LDAP server. For more information on configuring the LDAP server to be used, see LDAP Authentication.

To delete an existing user, click the delete link next to the user to delete.

Download this Manual
PDF (US Ltr) - 4.0Mb
PDF (A4) - 4.0Mb
EPUB - 3.2Mb
HTML Download (TGZ) - 3.1Mb
HTML Download (Zip) - 3.1Mb
User Comments
Sign Up Login You must be logged in to post a comment.