Re: row level security

Hi John, Since each of the your rows must have some form of client id why not add a where clause to each of your queries so that each client can only access his/her own data? regards Jerry jsmith wrote: > > Hi: > > We have an inventory-database of our customers, and an application that > will help them view their inventory. Intially, security was not an > issue, and therefore one customer could look up the inventory of > another. Now we would like to restrict access to data based on the > userid. > > How can I accomplish row-level security? Unfortunately I do not have a > whole lotta flexibility in terms of database design or the front-end. > > Any information helps. Thanks in advance. > > John -- Jerry Gitomer ICT Group jgitomer@ictgroup.com Langhorne PA jgitomer@yahoo.com Opinions are mine not those of ICT Group