Re: webdb restiction of access to certain records

You can set up a "translation table" of userid to customer_id. Create a view by joining this table to your customer information table, and in the where clause "where user_id = USER". Your user will only be able to view/manipulate the data that corresponds to their customer_id.

Wayne Linton

cat33dog_at_my-deja.com wrote:
>
> Hello
>
> I am trying to create a website that restricts access based on a
> customer id number.
>
> I have customers setup in Oracle with a password and username.
> Entering the correct username and password allows access to the data
> however the information is keyed by the customer id.
>
> So one customer cannot see the records in a table for another customer.
>
> I wish to have the customer login as usual.
>
> I am able to create links to the reports. I wish to be able to create
> a login form that will contain the customer id.
>
> I have been unsuccessful in creating a QBE form to do this.
>
> Is it possible to create a page with multiple links to reports?
> If so what is the best method?
>
> Thanks
>
> Patrick
>
> Sent via Deja.com http://www.deja.com/
[Quoted] [Quoted] > Share what you know. Learn what you don't.

-- 
Wayne Linton
wayne.linton_at_home.com