Re: Oracle proxy server for access control.

Actually VPDB-like capability exists in 8i (8.1.5-8.1.7) - some call it 'row level security' but the official term is 'fine grained access control' and it's fully documented in the admin guide which can be found at http://technet.oracle.com > documentation. The biggest single advantage of waiting for VPDB is that it's much, much easier to maintain.

/Hans

Frank van Bortel wrote:

> This is announced as Oracle9i (VPDB - or Virtual Private Databases)
>
> If you can't wait for that - define views, and use instead-of triggers
> to do datamanipulation.
>
> Hussam Khateeb wrote:
>
> > Hi;
> > Does anyone know any products for Oracle RDBMS access control?
> > Access control here means filtering client requests (that already connected)
> > according to some set of rules (for example not allowing SELECT query for
> > some client on some table in the database, although he may has privileges to
> > do it on the database, but, the access control program denies his access).
> >
> > Thanks in advance
> > Hussam
>
> --
> Gtrz,
>
> Frank van Bortel
Received on Fri Apr 27 2001 - 07:25:35 CEST