Re: Create database link from inside a stored procedure

In article <1143630635.259205.97520_at_v46g2000cwv.googlegroups.com>, gazzag says...
> Jeremy wrote:
> > Please explain why it is in your opinion a "mess" and the reasons why
> > this should not be permitted near a production environment?
> >
>
> What Oracle user has the privileges required to run this procedure and
> do you really want to provide a facility to create ad-hoc database
> links in a production environment?
>
> DDL should be run by a DBA, not by application code.
>
>

So assume the procedure is restricted to a user who logs in with a DBA (as far as the application is concerned) user (i.e. highest privilege the app provides).

The question remains - why is it a "mess" and should not be permitted in a production environment? I genuinely want to know and consider that a statment such as "DDL should be run by a DBA, not by application code" doesn't provide any kind of answer.

-- 

jeremy