Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: What the privilege is needed?
But this create statement CAN applied by super user -- "sys". I interest on this privilege requirement.
Ted Knijff wrote:
> 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 - 21:57:18 CST