Re: What the privilege is needed?

From: Andrew Deighton <andrewdeighton_at_phaldor-it.co.uk>
Date: Fri, 23 Feb 2001 09:55:53 -0000
Message-ID: <3a9634ba$1_4@news.intensive.net>

Extract from the SQL reference manual - a good starting point if you have a question of this nature:
"To create a function-based index in your own schema on your own table, you must have the QUERY REWRITE system privilege. To create the index in another schema or on another schema's table, you must have the GLOBAL QUERY REWRITE privilege. The table owner must also have the EXECUTE object privilege on the function(s) used in the function-based index" - Oracle8i SQL Reference Release 2 (8.1.6) Manual Oracle part number A76989-01

Regards
Andrew

"Diviner" <diviner_at_hknet.com> wrote in message news:3A94FD42.99E5CED8_at_hknet.com...
> If a user can create an index like this:
> "create unique index idx_UserAcc on UserAcc(Company, Login);"
>
> but failed on this creation:
> "create unique index idx_UserAcc on UserAcc(Company, Upper(Login));"
>
> So what is the privilege missing for this user?
>
> --
> Best regards,
> Diviner.
>
Received on Fri Feb 23 2001 - 03:55:53 CST