Re: Nested table and foreign key!!!!!

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 12 Sep 2003 09:16:29 -0700
Message-ID: <1efdad5b.0309120816.330a723d@posting.google.com>

yaobrucken_at_yahoo.fr (Brucken) wrote in message news:<59a217eb.0309090925.4bfae489_at_posting.google.com>...

> Hi!!!!!! 

> I am using oracle 9i server, I want to design a database for some web
> based appliaction, the user logins to this application will be using
> privileges assigned to him.
> I want to make two tables for defining these:
> First one table will be having all the privileges of the application
> having with their description.
> Second table will be having user with their login name and their
> correponding privileges in the nested table.
> So my question is that can i refer the values of privileges (foreign
> key) in nested table corresponding to particular employee with the
> privilege (primary key) defined in the first table?
> if this is possible please tell me the solution in detail.

go to asktom.oracle.com look up 'fine graned access control', fgac, or vpd its all the same thing. its also in the docs on OTN. It does all this for you with very little code.

its very easy to use. Received on Fri Sep 12 2003 - 11:16:29 CDT