5 Replies Latest reply: May 20, 2013 5:39 PM by Cjmurray-Oracle RSS

    Correction in oracle documentation

    Manik
      Hi all,

      I found small issue when running a script in the documentation.
      Verify the Setting Chain Privileges section the scripts mentioned in that section do not run at all (syntax errors probably)
      Please verify the same from your end too.

      I need this to be put forward by ace/moderators to Oracle documentation team.

      http://docs.oracle.com/cd/B19306_01/server.102/b14231/schedadmin.htm

      existing code in documentation -- (incorrect version in my opinion)
      BEGIN
      DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(DBMS_RULE_ADM.CREATE_RULE_OBJ, 'username'),
      DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE (
         DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, 'username'),
      DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE (
         DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, 'username')
      END;
      /
      
      
      BEGIN
         DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE (DBMS_RULE_ADM.CREATE_ANY_RULE,
                                               'username'),
      DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE (
         DBMS_RULE_ADM.CREATE_ANY_RULE_SET, 'username'),
      DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE (
         DBMS_RULE_ADM.CREATE_ANY_EVALUATION_CONTEXT, 'username')
      END;
      /
      To be modified as:
      BEGIN
         DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE (DBMS_RULE_ADM.CREATE_RULE_OBJ, 'username');
         DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE (DBMS_RULE_ADM.CREATE_RULE_SET_OBJ,
                                               'username');
         DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE (
            DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ,
            'username');
      END;
      /
      
      
      BEGIN
         DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE (DBMS_RULE_ADM.CREATE_ANY_RULE,
                                               'username');
         DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE (DBMS_RULE_ADM.CREATE_ANY_RULE_SET,
                                               'username');
         DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE (
            DBMS_RULE_ADM.CREATE_ANY_EVALUATION_CONTEXT,
            'username');
      END;
      /
      Cheers,
      Manik.