Yes, use a VIEW and grant permissions to the views.

--
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com


""cbmrussn"" <russn@...> wrote in message
news:ag4m7d+4d1q@......

> 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?
>