Re: restricting users

From: Jeremy Bettis <spam0930_at_hksys.com>
Date: Wed, 13 Oct 1999 16:31:04 -0500
Message-ID: <yP6N3.327$zz.1274@newsfeed.slurp.net>

How about creating a password protected role, granting permissions to the tables to the role, not to the users, and then altering the users default role none (instead of all, it defeats the password).

Then in your applications you can call "set role foo identified by pw" with the pw hard coded into the apps. The users will be able to connect using SQL*Plus, but they won't be able to do anything. --
Jeremy Bettis
jeremy_at_hksys.com
Cor <cor_larem_at_wxs.nl> wrote in message news:3803792F.1B0E_at_wxs.nl...

> I'm trying to find a way to restrict users in how they can connect to
> the ORACLE database. I want them to be able to connect from applications
> only, using Forms and Reports. For security reasons, I do not want them
> to be able to connect through any other tool, especially SQL+ of course.
Received on Wed Oct 13 1999 - 16:31:04 CDT