Re: using set role command in a logon trigger
- From: "Sriram Kumar" <k.sriramkumar@xxxxxxxxx>
- To: lizzpenaorclgrp@xxxxxxxxx
- Date: Wed, 4 Apr 2007 22:33:19 +0530
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@xxxxxxxxx> 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.
Other related posts:
