Oracle 11g Grid | Setting Preferred Credentials to avoid Priv Warnings
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.