index refers to funtion in DDL???
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: index refers to funtion in DDL???

  1. #1
    Join Date
    Mar 2008
    Posts
    21

    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

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    You do not give a developer any DBA privilege -period.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    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

  4. #4
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110
    why don't you create index for him?
    Looking for the greatest evil in the world? Look in the mirror.

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    i wonder why no one came down hardly on kool_max, for not mentioning the error number.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by abhaysk
    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?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width