How about a command that actually shows the comments on an object without having to read the system tables?
Security grants for creating and viewing the comments? Right now you can use various tricks to grant and revoke rights on system tables, giving various levels of security, but there is no non-system table approach to do this. If you can't view the comments or restrict access, you will have people going back to using the system tables and ignoring the new extensions. On 29 November 2011 15:28, Claudio Valderrama C. <cva...@usa.net> wrote: >> -----Original Message----- >> From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] >> Sent: Martes, 29 de Noviembre de 2011 6:41 >> > >> I believe it's better to have a system package with functions >> able to do >> that, instead of continue allowing these changes directly. > > Yes, no more fiddling with system tables, please. Add more DDL or system > functions. > I'm not sure about the requirements, so I will try to guess: > > - make all comments on the db NULL > - make all comments on a class of objects NULL (for example, all tables) > - make all comments on a specific object NULL (table+fields, proc+params, > etc). > > Something like that for rdb$%_source fields? > > C. > > > ------------------------------------------------------------------------------ > 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 ------------------------------------------------------------------------------ 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
