Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news-out.triton.net!triton.net!newsfeeder.triton.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: yaobrucken@yahoo.fr (Brucken)
Newsgroups: comp.databases.oracle.misc
Subject: Nested table and foreign key!!!!!
Date: 9 Sep 2003 10:25:37 -0700
Organization: http://groups.google.com/
Lines: 13
Message-ID: <59a217eb.0309090925.4bfae489@posting.google.com>
NNTP-Posting-Host: 132.207.83.21
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1063128338 29153 127.0.0.1 (9 Sep 2003 17:25:38 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 9 Sep 2003 17:25:38 GMT
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:131474

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.