BNFD - Your DBA NoteBook On The Net!!!
Showing posts with label Apps. Show all posts
Showing posts with label Apps. Show all posts

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