On 11/30/11 14:39, Dimitry Sibiryakov wrote: > 30.11.2011 9:08, Thomas Steinmaurer wrote: >> Or more "object type bound", e.g.: >> >> ALTER TABLE ... CHANGE OWNER TO ... >> ALTER VIEW ... CHANGE OWNER TO ... >> >> etc.. >> >> ALTER PROCEDURE ... DROP SOURCE; >> >> >> I have no idea if the SQL standard suggests here something. > I agree with changing owner, but dropping the sources is a way to nowhere. > Firebird > requires sources to recompile invalid objects. >
BLR remains. Btw, I also do not like practice of dropping the sources. People use it as a kind of protection for the database. This protection is not efficient. But if users need that feature I can better agree with adding SQL support than keeping an ability to modify system tables. ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
