RE: Table which store UserID

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Thu, 4 Jan 2001 10:48:57 -0000
Message-Id: <10731.125690@fatcity.com>

Use Roles & Priveliges. Create a privilege called level_one or something, and grant the specific object/system priveliges that that level user requires, then grant that role to the user. No extra tables required, and saves a hell of a lot of time, as you don't need to grant each specific privelige to each and every user, you just have one or maybe a few grants on roles.

HTH Mark

-----Original Message-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Nosie Sent: Thursday, January 04, 2001 09:32
To: Multiple recipients of list ORACLE-L Subject: Table which store UserID

Dear DBAs,

I am working on an application and designing the security. I want to use the existing Oracle security (user ID, password) without maintain or create additional tables (if really possible). However, I need additional information that will describe user's authority (i.e. user level 1 can do a certain transaction while user level 2 can not).

Does anybody know what practise to do this?

THALIA (THanks A Lot In Advance)

Y. Nosie

--

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

Author: Nosie
  INET: tekait11_at_bni.co.id

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 Thu Jan 04 2001 - 04:48:57 CST