How many groups will there be and how many records in the tables?

I'm not so sure this situation is going to be all that ideal.

I think it would be best to have the group figured out and stored on the
client and used directly in the client app. Otherwise, you could end up with
some queries too difficult to properly optimize.

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

----- Original Message -----
From: <s.beames@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, March 16, 2001 2:52 PM
Subject: [IBO] Re: Switching between views?


> 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
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>