Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: using set role command in a logon trigger

Re: using set role command in a logon trigger

From: Sriram Kumar <k.sriramkumar_at_gmail.com>
Date: Wed, 4 Apr 2007 22:33:19 +0530
Message-ID: <c515faee0704041003u36a33c32y8168abf575ea3a58@mail.gmail.com>


Hi,

There is this new feature in 10g that allows you to authenticate roles based on packages. You can use that feature for this situation of yours.

create role <> identified using schema.package;

Cheers

Sriram Kumar

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-l
Received on Wed Apr 04 2007 - 12:03:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US