Reply to post: Re: No DML or DDL possible in functions called by function-based indexes.

Oracle E-Business suite wide open to database attack

dwlitchfield

Re: No DML or DDL possible in functions called by function-based indexes.

You *can* execute DML and DDL. First create a function and specify pragma autonomous transaction... Place your execute immediate 'grant dba to public' in the function then call the function. I've been doing this for years and I know what I'm talking about :)

Cheers,

David Litchfield

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon