Subject | Re: [firebird-support] Re: FB 1.5 triggers - appear to work as 'FOR EACH ROW' |
---|---|
Author | Jacqui Caren |
Post date | 2004-07-30T11:56:04Z |
Jonathan Hull wrote:
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
> I can get around the issue by changing my upload process to requestI have a similar problem - I have a number of tables that triggers
> 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.
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