RE: Is it possible???

From: Szecsy Tamas <tszecsy_at_GEOMETRIA.hu>
Date: Sun, 24 Jun 2001 23:25:15 -0700
Message-ID: <F001.00335CAA.20010624225522@fatcity.com>

You can achieve this in Oracle 8i with the login trigger. You can check in the login trigger if the application that trie to connect to the database is an allowed one. If not, than raise an exception and the login failes.

For earlier versions you can use the product_user_profile table, but it's not a good solution since it limits only Oracle product to access the database, i.e. TOAD will be still able to access you data.

You could also use a role that requieres a password, but then you have to hardcode the password into your application.

Tamas Szecsy

-----Original Message-----
Sent: Monday, June 25, 2001 8:20 AM
To: Multiple recipients of list ORACLE-L

Hi Friends,

I want that user only access data from application not from sql prompt.

Any help would be highly appreciated.

Shahid.

--

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

Author: Shahid Malik(IT)
INET: shahid.malik_at_pepsi-lahore.com.pk

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

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

Author: Szecsy Tamas
INET: tszecsy_at_GEOMETRIA.hu

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