This discussion is archived
5 Replies Latest reply: May 20, 2013 3:39 PM by cjmurray RSS

Correction in oracle documentation

Manik Expert
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points