Re: What the privilege is needed?

The problem is that functions UPPER(login), are not supported in indexes on all versions. Best is :

add a field upper_login
create a trigger :
CREATE OR REPLACE TRIGGER SET_UPPER BEFORE     INSERT,UPDATE ON USERACC FOR EACH ROW BEGIN
 :new.upper_login = UPPER(Login);
END;
And now you can add an index on it.
Or else, upgrade.
Hth

Ted

On Thu, 22 Feb 2001 19:51:30 +0800, Diviner <diviner_at_hknet.com> wrote:

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

EMail: knijff_at_bigfoot.com Received on Thu Feb 22 2001 - 12:32:33 CST