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

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_at_x.washington.edu
(replace 'x' with a 'u' to reply)