Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: using set role command in a logon trigger
Laura,
Which Oracle version is involved?
Dennis Williams
On 4/4/07, laura pena <lizzpenaorclgrp_at_yahoo.com> wrote:
>
> Hello,
>
> I have been asked to set specific roles when a user logs into oracle from
> a specific application.
>
>
> Meaning if the user is using for example Toad we only want that user for
> that session to have read-only privs.
>
> So I am wondering if it is possible to use the set role command in a
> trigger?
>
> I can use sys_context and v$session to determine what application the user
> has loged in from but not sure about using the set role command.
>
> Can anyone confirm this can be done or offer alternatives?
>
> Many Thanks,
> Laura
>
> ------------------------------
> Looking for earth-friendly autos?
> Browse Top Cars by "Green Rating"<http://autos.yahoo.com/green_center/;_ylc=X3oDMTE4MGw4Z2hlBF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDZ3JlZW5jZW50ZXI->at Yahoo! Autos' Green Center.
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 04 2007 - 18:46:05 CDT