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: how to create VPD with SINGLE ORACLE USER ?

Re: how to create VPD with SINGLE ORACLE USER ?

From: yikaikai <yikaikai_no_spam_at_sina.com>
Date: Tue, 4 Mar 2003 20:29:32 +0800
Message-ID: <b42654$18ps$1@mail.cn99.com>


Hi, come here to see it:
http://chinaunix.net/forum/viewtopic.php?t=21835&highlight=virtual "yannduv" <yannduv_rem_at_club-internet.fr> 写入消息新闻 :3e6485d0$0$7884$626a54ce_at_news.free.fr...
> hi!
> i'd like create a VPD with oracle: here is my configuration:
>
> only 1 user (schema) wich is in reallity my application : "WWW_CUSTOMERS"
> Application WWW_CUSTOMERS is a web based application distributed in ASP
mode
> (jsp + beans).
>
> This application has 2 tables "CUSTOMER" and "DEPT"
>
> My users are stored in another schema "WWW_PORTAL" > tables "USERS" and
> "GROUPS"
>
> Users have rights to acces to CUSTOMER records but only if they are in the
> DEPT "arkansas" (for example)
>
> i'd like to implement right access with VDP.
>
> My question:
> How to implement VPD with a "single oracle user"
> does anyone has experience with it ?
>
> thanks in advance.
>
>
>
>
>
Received on Tue Mar 04 2003 - 06:29:32 CST

Original text of this message

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