Oracle Views and Permissions

Hi,

If I have a Table X in Schema A with 1000 rows spilt between 3 companies (company_id 1,2,3).

I then create a view called Y in Schema B which is a Read Only View of table X but only for rows where company_id = 3.

To create this view Schema B must have a SELECT privilege on Table X.

The problem is that, by assigning this select priv Schema B can now view ALL rows in Table X directly and bypass the view.

Is there any way to prevent this by allowing access only to the view and not the underlying table with company 1,2 data that is confidential.

I'm using Oracle 8.1.7.4

Thanks for the help Received on Tue Jul 12 2005 - 09:58:55 CDT