Application role

From: Franky <vraag_at_bigfoot.com>
Date: Wed, 6 Nov 2002 12:21:30 +0100
Message-ID: <3dc8fb3a$0$73799$ba620e4c@news.skynet.be>

In Sql Server an application role can be created so that users cannot connect to the database if they don't use the program. In that program you first connect to the database and the exec a stored procedure using a password. Then you can select, delete, update the records in the database. If you use another tool (MsAccess, Query analyzer, ...) you cannot select, delete and update the records.

Can you create the same in Oracle 8i or 9i?

Thanks for the answers,

Franky Received on Wed Nov 06 2002 - 05:21:30 CST