Re: Security question: Forms / SQLPlus

[Quoted] Assign a select only role to the user as his default role (Use the ALTER USER command). This way, accessing the database via SQL*Plus, etc., will only allow the user to view the data. In your application, dynamically set the role for that user to whatever you want him to have for that session.

HTH,
Martin Bronstein

Andrew KEATING wrote:

> Sorry, I'm not sure that I understand, do you mean dyniamically give the
> user a role from with the application, just for the duration of the session
> ? If so, what if he (or she) connects via the application and at the same
> time via SQLPlus ?
Received on Fri Sep 25 1998 - 22:49:44 CEST