index refers to funtion in DDL???

[kool_max]

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

[PAVB]

You do not give a developer any DBA privilege -period.

[JChiappa]

kool_max, following PAVB I would say : except on the case of test/development database, WHY you (dba) is not creating the necessary objetcs ? See, by definition a developer know NOTHING about PCTFREE, tablespaces, compression and N+1 other important things to get top performance from an object.... 99 times in 100, a developer will do a CREATE INDEX with all the options default, what NOT is always the recomended way to work....
Anyway, answering : http://asktom.oracle.com/tkyte/article1/index.html explain about FBIs, the prvs required are QUERY_REWRITE_ENABLED=TRUE and QUERY_REWRITE_INTEGRITY=TRUSTED

Regards,

Chiappa

[Tuma]

why don't you create index for him?

[abhaysk]

i wonder why no one came down hardly on kool_max, for not mentioning the error number.

[PAVB]

i wonder why no one came down hardly on kool_max, for not mentioning the error number.

May be because there is a bigger issue to discuss?

[abhaysk]

Yea.. true, but some company policy allow developers to create structures (though it should be only on dev/qa enviroments).. or it may be such that there are application DBAs?.. whatever case may be, i was expecting someone would have come down heaily on missing info.. lol