MySQL Enterprise Monitor is available as part of the MySQL Enterprise subscription, learn more at http://www.mysql.com/products/.
The Manage Users panel lets you create, delete and manage individual users that have access to MySQL Enterprise Service Manager.
A user account is required to log into the MySQL Enterprise Monitor User Interface. There are four types of users with varying privileges:
A user with the role of
managercan perform all operations within MySQL Enterprise Service Manager, including changing the server configuration, adding and removing users, and viewing query analyzer and other data.
Users with the
dbarole 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 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
dbarole for a user.
read-onlyrole is identical to the
dbarole, but is unable to make any changes to the configuration of MySQL Enterprise Monitor, although they can view the current settings.
agentrole 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 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 15.4, “User Preferences”.
If you installed the Advisors through the MySQL Enterprise Monitor User Interface, you have probably configured the settings for the root role user already. (See Section 15.1, “Global Settings” and following for more information about this topic.)
To receive support-related updates, configure the My Oracle Support (MOS) credentials for at least one user. These settings were set up on the first login to the Monitor UI. For information on changing these settings, see Section 15.1, “Global Settings”.
To edit an existing user's information, select the
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
next to the user to delete.