> On Sep 1, 2014, at 4:42 PM, Dmitry Yemanov <firebi...@yandex.ru> wrote: > > 02.09.2014 00:22, James Starkey wrote: > >> What possible user applications are going to be doing procedure and >> trigger definitions that require the source be omitted? > > Whatever user application that works with the database and executes > metadata upgrade scripts itself, without invoking ISQL.
Do you really think there are any? Seriously? Really? > >> And what syntax are you talking about? > > Option (1) from the list of solution being discussed, i.e. new DDL > statement. You just argued that changing scripts was a bad idea. This sounds more like a shotgun blast than a reasoned argument. > >> The problem with write access to RDB$TRIGGERS and RDB$PROCEDURES (or >> whatever the correct names are) is that anybody with privilege can store >> crap, which is the reason they were to be made read-only except for the >> system. > > We may allow *only* setting rdb$source to NULL and *only* for SYSDBA / > DBO, everything else will still be prohibited. Ok, explain about simple again. This sounds like a whole raft of conditions. Would it have to be a literal null or would a null input parameter be ok? How about an express that turns out null? What if somebody tried to set it to something other than null? An exception: rdb$cantsetfieldtoanythingbutnullandthenonlyifyoursysdba? And how about an empty but not null blob? I gotta say that a table that has only one field writable and then only assignable to null and only if the user is SYSDBA is a pretty crude hack. Not quite elegant. Kinda sort of I painted myself in the corner and couldn't find any other way out feature. > > > Dmitry > > > ------------------------------------------------------------------------------ > Slashdot TV. > Video for Nerds. Stuff that matters. > http://tv.slashdot.org/ > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel ------------------------------------------------------------------------------ Slashdot TV. Video for Nerds. Stuff that matters. http://tv.slashdot.org/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
