Oracle 11g Grid | Setting Preferred Credentials to avoid Priv Warnings

Posted By Sagar Patil

Generally we use grid for performance and availability monitoring . I have a NON- DBA user configured at a grid preferred credential.   Sometimes I have to use grid to carry DBA tasks and here is a way to switch database preferred credentials & become a DBA

select “Preferences” and click on Preferred Credentials

Since I wish to change credentials for my Database Instance running streams I will choose “Database”

select required Target and alter username/password fields. Click on “Test” to verify credentils.

I have logged out

When I logged in again, I don’t see same privilege error

This issue could be entirely resolved by creating different user for each Grid user and adding separate database preferred credentials.

Leave a Reply

You must be logged in to post a comment.

Top of Page

Top menu