Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Role Question
> Is there anyway to create a role that will allow only row level
> access.
The latest releases of Oracle have fine grained access control that
allows you to grant access at the data level. I'm not entirely sure
which release it came in with (I know it's there in 8.1.5), but you
might want to look into this to see if it will do what you want.
There's an article about it in the July 99 edition of Oracle magazine
which you can see on line at
http://www.oracle.com/oramag/oracle/99-Jul/49toc.html