Subject Re: [ib-support] Does Firebird support column-based locking?
Author Jason Wharton
Yes, use a VIEW and grant permissions to the views.

Jason Wharton
CPS - Mesa AZ

""cbmrussn"" <russn@...> wrote in message
> Is it possible to have specific permissions on specific columns in a
> table, based on another column?
> For example, if I have ATable with FieldOne, FieldTwo and LockField,
> can I lock FieldTwo to read-only if LockField has a secific value,
> through the FireBird engine?
> Reading through the documentation, this doesn't appear possible, but
> I would think that it could be possible.
> Thanks?