Wednesday, July 3, 2013

Enterprise Manager 12c Named and Preferred Credentials

In this demo I show how to setup Named and Preferred credentials for target password management in Enterprise Manager 12c.

Do you always find yourself or your teammates typing in the password for targets in Enterprise Manager 12c? Do you have a long list of saved passwords and you do not know what save credentials are for what target? Do you have quarterly password changes that make it a nightmare to manage the passwords for targets in Enterprise Manager 12c.

Using Named and Preferred credentials will be easier to manager all credentials for your different targets in Enterprise Manager.

Setup Named Credentials


1. Log into Enterprise Manager Cloud

2. Click Setup>Security>Named Credentials













3. Click Create


4. Type in the name and description for the credential. Select the target type for the authorization and the credential type. Set the username, password and role for the credential properties. Now test the credentials by clicking "Test and Save" button.

For my example I set database instance and database credentials. This named credential is for sys account with sysdba role privileges.


5.Click the magnifying glass.






















6. Select the target or type in the target name to search. Click Select button when ready.



7. Now click the "Test and Save" button.






















8. You will see credential operation successful. Select the newly created credential to review the details. Now click the create icon again to add a non-sysdba credential.






















9. Type in the name and description for the credential. Select the target type for the authorization and the credential type. Set the username, password and role for the credential properties. Now test the credentials by clicking "Test and Save" button.

For my example I set database instance and database credentials. This named credential is for system account with normal role privileges.





















10. Click the magnifying glass.






















11. Select the target or type in the target name to search. Click Select button when ready.























12. Now click the "Test and Save" button.





















13. You will see credential operation successful. Select the newly created credential to review the details. Now click the create icon again to add host target credential.





















14. Type in the name and description for the credential. Select the target type for the authorization and the credential type. Set the username, password and role for the credential properties. Note you can set run privileges like sudo. Now test the credentials by clicking "Test and Save" button.

For my example I set host and host credentials. This named credential is for OS authentication.





















15. Click the magnifying glass.





















16. Select the target or type in the target name to search. Click Select button when ready.





















17. Now click the "Test and Save" button.





















18. You will see credential operation successful. Select the newly created credential to review the details.





















Setup Preferred Credentials


1. Click Setup>Security>Preferred Credentials





















2. Select the target type  and click Manage Preferred Credentials.





















3. Select target name with SYSDBA database credentials and click set.





















4. Select the named credential with SYSDBA role created early  and click test and save.





















5. You will see named credentials association done successfully. You will see the target you selected now has a preferred credential set.





















6. Now select the target with normal database credentials and click set.





















7. Select the named credential with normal role created early and click test and save.





















8. You will see named credentials association done successfully. You will see the target you selected now has a preferred credential set. Now we will set the host credentials, click the preferred credentials link below the successful message.





















9. Select the host target type and click manage preferred credentials.





















10. Select the host and click set.





















11. Select the named credential created early and click test and save.





















12. You will see named credentials association done successfully. You will see the target you selected now has a preferred credential set. Now we will set the database host credentials, click the preferred credentials link below the successful message.


















13. Select database instance target type and click manage preferred credentials.





















14. Select the database target for database host credentials and click set.





















15. Select the named credential created early and click test and save.





















16. You will see named credentials association done successfully. You will see the target you selected now has a preferred credential set.




















Conclusion

Setting named and preferred credential help with password management for your Cloud Control 12c targets.

You can use the named credentials when you need to log into pages that require database log in credentials.






















When creating jobs you can use the preferred credentials to easily set the credentials needed to execute jobs.





Follow me on Twitter

3 comments:

  1. Absolutely brilliant article, you have explained everything about enterprise password management in crispy and subtle manner.Thanks for sharing this great piece of article with us.

    ReplyDelete

About Me

My photo

Senior DBA with over 16 years experience, specializing in "Database Performance Tuning" and High Availability (RAC, Data Guard & Oracle Golden Gate).