Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Role Question

Re: Role Question

From: mkeene <matthew_keeneNOmaSPAM_at_ansett.com.au.invalid>
Date: Thu, 16 Dec 1999 21:27:25 -0800
Message-ID: <06a58763.f5186f29@usw-ex0102-012.remarq.com>


> 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

Received on Thu Dec 16 1999 - 23:27:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US