DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: QUERY REWRITE,QUERY_REWRITE_ENABLED,QUERY_REWRITE_INTEGRITY!

  1. 07-23-2001, 02:17 PM #1
    amitstora
    amitstora is offline Senior Member
    Join Date
    Feb 2001
    Posts
    286
    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!
    Reply With Quote Reply With Quote
  2. 07-23-2001, 04:54 PM #2
    jhmartin
    jhmartin is offline Member
    Join Date
    Jun 2001
    Posts
    242
    Those are the priveleges required to create a function based index.

    See http://otn.oracle.com/docs/products/...dexes.htm#2943
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width