Home » SQL & PL/SQL » SQL & PL/SQL » Insufficient Privileges when creating function-based index .....
Insufficient Privileges when creating function-based index ..... [message #223821] Sun, 11 March 2007 17:48 Go to next message
m_arafa
Messages: 36
Registered: June 2006
Member
hi,

I'm using oracle9i.0.1

first , I put the following lines in ora.ini file :-

QUERY_REWRITE_ENABLED=TRUE
QUERY_REWRITE_INTEGRITY=TRUSTED

and then, when i create function-based index like :-

create index idx on emp(sal+comm);

and it still give me error:-
Insufficient Privilege

thanks ....
Re: Insufficient Privileges when creating function-based index ..... [message #223825 is a reply to message #223821] Sun, 11 March 2007 21:07 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
In order to create a Function Based Index on your tables, you must be granted the QUERY REWRITE privilege.
Previous Topic: missing GLOBAL keyword
Next Topic: ERROR
Goto Forum:
  


Current Time: Fri Dec 09 23:01:51 CST 2016

Total time taken to generate the page: 0.10944 seconds