Re: [Basic logon architecture for multiple apps in a db]

From: MOHAMMAD AMER <mohammad_amer_at_usa.net>
Date: Fri, 13 Apr 2001 07:23:50 -0700
Message-ID: <F001.002E91B4.20010413065532@fatcity.com>

HI dba man,
I made my own security system by making database users and giving them synonyms to access the owners objects,also I created public synonyms for the objects .Then I created roles and assigned them to menu items in the main menu and sub-menus.After creating the user (in a form I developed myself,)I made another form to give certain functions(forms) to different users,and in this form I grant the roles accordingly.

If this solution seems ok with you,let me know,I 'll give you more tips and tricks.
By the way,the system is secured and the customer is satisfied.

                                                         Oracle dba

____________________________________________________________________

Get free email and a permanent address at http://www.netaddress.com/?N=1
--

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

Author: MOHAMMAD AMER
  INET: mohammad_amer_at_usa.net

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 Apr 13 2001 - 09:23:50 CDT