How To Change the 10.2 Database Control MGMT_VIEW Password

	Doc ID:	455450.1	Type:	HOWTO
	Modified Date :	24-MAR-2008	Status:	MODERATED

In this Document
  Goal
  Solution
  References

---

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Enterprise Manager Grid Control - Version: 10.2
Information in this document applies to any platform.

Goal

The 10.2 Database Control web site repository is missing the MGMT_VIEW_PRIV.CHANGE_VIEW_USER_PASSWORD procedure normally found in the Grid Control repository. This procedure is normally required to change the MGMT_VIEW user password. An alternative method is presented here.

Solution

The following steps may be performed to change the MGMT_VIEW user password if the MGMT_VIEW_PRIV.CHANGE_VIEW_USER_PASSWORD procedure is not available in the Database Control repository (sysman schema):

1. Call MGMT_VIEW_PRIV.SET_VIEW_USER_CRED('<new_password>');
This calculates the random password for the MGMT_VIEW user and
saves it

2. Call MGMT_VIEW_PRIV.GET_VIEW_USER_CRED;
Get the random password saved in step 1.

3. Call EXECUTE IMMEDIATE 'alter user MGMT_VIEW identified by <new pwd>';

 

All of these steps can be accomplished by creating this procedure, using the real intended password character string in the field denoted by <new_password>:

declare
c_secret varchar2(100);
c_user varchar2(100);
c_pwd varchar2(100);

begin
c_secret := '<new_password>';
sysman.MGMT_VIEW_PRIV.SET_VIEW_USER_CREDS(c_secret);
Sysman.mgmt_view_priv.get_view_user_creds (c_user, c_pwd);
Sys.dbms_output.put_line (c_user);
Sys.dbms_output.put_line (c_pwd);
EXECUTE IMMEDIATE 'alter user MGMT_VIEW identified by '||c_pwd;
end;
/