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.
Received on Tue Sep 09 2003 - 12:25:37 CDT
