Re: Access Limitation

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Fri, 21 Feb 2003 22:44:10 +0100
Message-ID: <ba7d5v0vil3v17c9chof8dmi5bgh9osqd8@4ax.com>

On Fri, 21 Feb 2003 21:03:18 GMT, "Life Learner" <PowerE2E_at_yahoo.com> wrote:

>Hi there,
>
>I'd like to know how to prevent end users from accessing system directly via
>sqlplus, toad etc, while let them do their work only in application level
>like forms, proc etc.
>
>thx.
>

Your best option is to grant them access through a role which is not enabled by default. When you log in using the app, your startup code issues the appropiate commands to enable the role.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Feb 21 2003 - 15:44:10 CST