Grid Control Repository: How to Change the Password of the MGMT_VIEW User? (Doc ID 374382.1)

Last updated on MAY 07, 2015

Applies to:

Enterprise Manager Base Platform - Version 10.1.0.2 to 11.1.0.1 [Release 10.1 to 11.1]
Information in this document applies to any platform.

Goal

During repository creation, a user named MGMT_VIEW is also created. This view is used by Grid Control for the reporting framework to execute queries for 'Table from SQL' and 'Chart from SQL' report elements. The password for this user is created based on the SYSMAN password entered during the installation. OMS is the only entity which uses this account, hence the password is not exposed to the user. However, you can still change the password if you choose, which requires that you bounce the OMS.

 This article provides a quick reference on how to change the MGMT_VIEW password used by the Grid Control Repository.

Note: As this account is used only by the OMS, there should never be a need to modify the password of this account manually unless in some special cases, for example: the MGMT_VIEW account is locked in the Repository.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms