Re: Table which store UserID

If I the security data is used to determine what the application can do by user...
You could add another table(s) that store detailed user information. The application, after connecting to the database, could access the table(s) with the user name (user) and retrieve the detailed security data. The application would then be responsible for implementing the security.

If I the security data is used to determine what the data user can select etc... You could use views or if you are using 8i Enterprise Server use fine-grained access control.

Todd Carlson
Oracle 8 Certified DBA
Bunge Corporation

|--------+----------------------->

|        |          "Nosie"      |
|        |          <tekait11_at_bni|
|        |          .co.id>      |
|        |                       |
|        |          01/04/2001   |
|        |          03:31 AM     |
|        |          Please       |
|        |          respond to   |
|        |          ORACLE-L     |
|        |                       |


|--------+----------------------->

  >----------------------------------------------------------|
  |                                                          |
  |       To:     Multiple recipients of list ORACLE-L       |
  |       <ORACLE-L_at_fatcity.com>                             |
  |       cc:     (bcc: Todd Carlson/STL/BungeCorp/Bunge/US) |
  |       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).