Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> design suggestions for apprentice

design suggestions for apprentice

From: Rivera, Claudia <crivera_at_utep.edu>
Date: Fri, 1 Dec 2000 11:14:43 -0700
Message-Id: <10697.123421@fatcity.com>


I am working in a database project that involves the following.

table admins <--------relation one to many ------ table accounts

The people belonging to the table admins can create accounts, delete accounts, or modify accounts.

Now, there is supposed to be ONLY one super_admin that is going to administrate the admins (create, modify, delete)

I am thinking in just creating a new relation like this:

table super_admin <---------- relation one to many ------- admins

But is it worth it to create a table just to have one record on it (the only super_admin).
Or is there any other more efficient way to to this???

Thanks for your input.

--------------Claudia Rivera-----------------
Received on Fri Dec 01 2000 - 12:14:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US