I got schooled today on this topic.
Our internal users were having issues trying to restore database through our front end web interface.
They were able to pick the database server but the drop down for all the schemas were blank.
Quickly getting to the point the public synonym for sys.dba_users was missing.
Easy way to see this is from enterprise manager drill down to Schema > Public> there should be an object called DBA_USERS.
To fix our issue loggin in as Sys
CREATE PUBLIC SYNONYM DBA_USERS FOR DBA_USERS;
COMMIT;
After that was ran all of the schemas populate the drop down list now.
Hope this will help people.
No comments:
Post a Comment