security question

I want to add new users to my Oracle7 database. I want to limit the information that they will be able to see. I would like to create a view the limits the records that they can see in the customer table. The criteria for determining which records they can access is based on the customer table and also on a distributor table that has a foreign key relationship with the customer table. The problem is I can't create a view that joins these two tables and also perform inserts, updates, and deletes through this view. I really don't want to duplicate the table either. There is already a large forms3.0 application accessing these tables and I don't want to have to modify a lot of code. Any ideas on how this security can be provided through roles, views, etc? Any help would be appreciated. please email at DMNortunen.aol.com. Thanks in advance! Received on Thu Feb 16 1995 - 06:30:08 CET