Row Level Security

I'm trying to implement a simple row level user based security scheme using views. I have the following schema:

create table access_table (id number(9), granted_user varchar2(30));

create table base_table (id number (9), description varchar2(80));

create or replace view base_view
as select *
from base_table
where exists (select 'x'

              from access_table
              where access_table.granted_user=user
	      and   access_table.id=base_table.id)

Thus, I can grant only the view to another user, and grant and revoke access on each row by simply inserting or deleting a row into access_table.

This works on Oracle (7.1.6) because there is no join in the where clause.

I was wondering if this behavior is standard across other databases, or am I exploiting functionality specific to Oracle.

Please e-mail replies.

Thanks in advance,
Rob

-- 
*****************************************************************************"The ones who love us best / Are the ones we'll lay to rest / And visit their 
graves on holidays at best.
 The ones who love us least / Are the ones we'll die to please / 
 And if it's any consolation / I don't begin to understand." -- The 
Replacements

Robert Lippmann
Intelligent Interactions
201 N. Union Street, Suite 110
Alexandria VA, 22314
(703) 706-9500