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.

>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?

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.

CUT & PASTE exactly what you did & how Oracle responded.

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)

>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