BNFD - Your DBA NoteBook On The Net!!!

Monday, April 21, 2008

Resource Role is a must for Apps

If we revoke resource role then while patching it will throw errors.

Example:

CREATE OR REPLACE PUBLIC SYNONYM qp_list_headers_all_b FOR QP.qp_list_headers_b
AD Worker error: The following ORACLE error:
ORA-01031: insufficient privileges