using set role command in a logon trigger

From: laura pena <lizzpenaorclgrp@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Wed, 4 Apr 2007 07:26:46 -0700 (PDT)

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" at Yahoo! Autos' Green Center.

Follow-Ups:
- Re: using set role command in a logon trigger
  - From: Sriram Kumar
- Re: using set role command in a logon trigger
  - From: Jared Still
- Re: using set role command in a logon trigger
  - From: Dennis Williams

using set role command in a logon trigger

Other related posts: