Perhaps I could store the user ID locally, identify his/her group,
and change the logon ID to one representing the group, and then use
USER in my SELECT statements.......?

--- In IBObjects@y..., s.beames@m... wrote:
> Hi,
> my program will be used by two distinct user groups. They will
> share the same tables, but their data will be seperate, perhaps by
> use of a DEPT CHAR(3) column in each shared table. I know I can use
> Views to allow each group to access their own data only, but I'm
not
> sure how my program can dynamically switch between views in all my
> TIB_Query SELECT statements etc, according to which group the
current
> user is from.
>
> Can anyone tell me if it is possible?
> (BCB5 / IBO 3.6Cf / Firebird 0.9.4.41 / Win95)
>
> Thanks,
> Steve