Subject Re: [firebird-support] Re: FB 1.5 triggers - appear to work as 'FOR EACH ROW'
Author Jacqui Caren
Jonathan Hull wrote:

> I can get around the issue by changing my upload process to request
> the next sequence, supplying it as part of the process. However, it
> would be ideal at the DB as there is a minor chance that some rogue
> sysadmin may decide to do a little direct manipulation of the data
> while an upload is occurring.

I have a similar problem - I have a number of tables that triggers
cannot easily control access to.

I revoke any access grants for all but the stored procedures used
to update the table. This way I can be (more) sure no clueless
newbie will trash my data - I hope :-)

Of course, if the SA decides to grant himself access then ...

Question - does firebird have 'comment on field' or 'comment on table'
allowing storage of comments against tables and fields?

I find this invaluable and use it extensively in Erwin, Marathon etc
however I cannot find an SQL construct for creating such comments
in FB1.5

Jacqui