index refers to funtion in DDL???
hello,
This developer need some index grant. Which is fine. i have given him create index grant. but its still not working. so i given him create any index grant. Still not woking. here is what i got from him.
" I need whatever special privilege(s) are needed to create indexes that refer to functions in the DDL. Here would be an example, which I cannot currently created under my existing privileges.
CREATE INDEX IDX_EDIELIGCOVIDENROLLCOVERAGE ON MHP_EDI_ENROLLCOVERAGE
(TO_NUMBER("EDIELIGCOVID"))
NOLOGGING
NOPARALLEL;
-----------
so what can be done to give him privilege to create index that refer to funtions in the DDL. Thanks for the help