QUERY REWRITE,QUERY_REWRITE_ENABLED,QUERY_REWRITE_INTEGRITY!

[amitstora]

Hi!

Queries:

1.What is meant by the following:

a.SQL> GRANT QUERY REWRITE TO SCOTT;
Grant succeeded.
b.SQL> ALTER SESSION SET QUERY_REWRITE_ENABLED=TRUE;
Session altered.
SQL> ALTER SESSION SET QUERY_REWRITE_INTEGRITY=TRUSTED;
Session altered.

Regards,

Amitstora!

[jhmartin]

Those are the priveleges required to create a function based index.

See http://otn.oracle.com/docs/products/...dexes.htm#2943