Topic: ACCESSIBLE BY for EXECUTE IMMEDIATE
Good afternoon. There is such problem: it would be desirable to implement "white lists" for performance of procedures, but a problem that procedures are caused through dynamic SQL. Even if procedure from the white list from which it is fulfilled EXECUTE IMMEDIATE, all the same produces an error "PLS-00904: insufficient privilege to access object...". Someone can faced it. Whether it is possible ? That it was clearer: procedure And Would cause procedure through dynamic SQL. Procedure And is in "white lists" of procedure B.