Re: design suggestions for apprentice

From: <Hannah.M.Doran_at_sb.com>
Date: Fri, 1 Dec 2000 15:06:05 -0500
Message-Id: <10697.123437@fatcity.com>

uhm,

create roles:

     Acct_admin
     Admin_Admin

     Assign  Admin_Admin role to your super user
     Assign Acct_Admin to all other

     Set up the object privildege under each role.

"Rivera, Claudia" <crivera_at_utep.edu> on 12/01/2000 01:18:36 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: design suggestions for apprentice

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-----------------

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Rivera, Claudia
  INET: crivera_at_utep.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Dec 01 2000 - 14:06:05 CST