1 Reply Latest reply on Jul 4, 2013 9:12 AM by Richard Harrison .

    DDL Query for ANY EVALUATION CONTEXT and ...

    user9544115

      Hi there,

       

      this is a cross posting from SQL: maybe I will have more luck here:

       

      Problem: there is a grant in my DB:

       

      GRANT CREATE ANY EVALUATION CONTEXT to "MYNAME";

       

      Which DDL can I use to get this grant:

       

       

      SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','MYNAME') from dual;

       

      SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT', 'MYNAME') FROM DUAL;

       

      SELECT DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT', 'MYNAME') FROM DUAL;

       

      SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT', 'MYNAME') FROM DUAL;

       

       

       

      are NOT working. BTW: same for

       

       

       

      GRANT DROP ANY EVALUATION CONTEXT to "MYNAME";

       

      GRANT CREATE ANY EVALUATION CONTEXT to "MYNAME";

       

      GRANT EXECUTE ANY EVALUATION CONTEXT to "MYNAME";

       

       

       

      Also I am searching for the DLL for

       

       

      CREATE OR REPLACE CONTEXT CONTEXT_COE USING MYNAME.PKG_CONTEXT

       

       

       

       

       

      Any ideas are very welcome!!!!

       

       

       

      Thanks,

       

      H