Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2009
    Posts
    15

    Unanswered: Oracle 10.1.0.2 vs. 10.2.0.1

    I am using Oracle 10.1.0.2 on Windows XP SP2, connected with sysdba user.
    When I try to grant "ALTER ANY RULE SET" to any user i get "ORA-00990: missing or invalid privilege".
    It looks like this privilege is not supported on 10.1.0.2 version, although it works fine on 10.2.0.1 in the same conditions.
    Anyway, when I do "select * from dba_sys_privs order by privilege" I see ALTER ANY RULE SET as an available privilege for sysdba users (on 10.1.0.2). Why doesn't it work? Does anyone have a link to the official documentation saying that this is not supported on Oracle 10.1.0.2?



    Thank you.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Does anyone have a link to the official documentation saying that this is not supported on Oracle 10.1.0.2?
    Do you have a link to the official documentation saying that this is supported on Oracle 10.1.0.2?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2009
    Posts
    15
    I could use some help instead of your smart-line-wannabe. Since I'm asking the question, it's obvious I didn't find something related to this into documentation. Your question does not answer my question...



    Thanks.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    CUT & PASTE exactly what you did & how Oracle responded.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by alecs
    Does anyone have a link to the official documentation saying that this is not supported on Oracle 10.1.0.2?
    Maybe the two following links to the official documentation can help you:

    The GRANT statement does not list "ALTER ANY RULE SET" as a valid option http://download-uk.oracle.com/docs/c...ments_9013.htm

    And according to this official documentation http://download.oracle.com/docs/cd/B...s.htm#BABCCCIE a special procedure is required to grant privileges to rule sets

    (Note: I have never used rule sets, I simply looked them up in the official documentation, so I might be missing something here)

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Index
    does not mention ALTER ANY RULE or RULE SET

    neither does
    Index

    On the surface it appears you are dealing with an "feature" which has not yet been officially released.
    If you have evidence to the contrary in any Oracle manual, please post URL.

    For definitive answer, submit Service Request on http://metalink.oracle.com & post results back here
    Last edited by anacedent; 07-03-09 at 23:10.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •