Re: row level security - Check out RecordSecurity

Hi John: You can create views based on userids and select from those views based on the user or change the queries at the front-end to select a subset of the data (if you don't want to create views) or depending upon the RDBMS, try a middleware solution if you don't have flexibility at the front-end. or see if RecordSecurity from http://www.poorva.com is a solution for you. Shree > 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