Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!logbridge.uoregon.edu!newshub.sdsu.edu!elnk-nf2-pas!elnk-pas-nf1!newsfeed.earthlink.net!sn-xit-02!sn-xit-06!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Daniel Morgan Newsgroups: comp.databases.oracle.misc Subject: Re: Nested table and foreign key!!!!! Date: Tue, 09 Sep 2003 16:52:22 -0700 Organization: ATS Message-ID: <1063151522.701259@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <59a217eb.0309090925.4bfae489@posting.google.com> In-Reply-To: <59a217eb.0309090925.4bfae489@posting.google.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@pond178.drizzle.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 29 Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:131483 Brucken wrote: >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. > > Why are you trying to reinvent the wheel? Everything you are talking about building is already available in Oracle. Charging by the hour? ;-) -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)