> On 11/30/11 02:42, Frank Ingermann wrote: >> DROP SOURCE OF [<procedure name>|<trigger name>|*] >> or >> CHANGE OWNER OF [<db object>|*] TO<new_owner> > > This approach looks much better than use of system package.
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. Regards, Thomas ------------------------------------------------------------------------------ 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
