Re: using set role command in a logon trigger

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 4 Apr 2007 13:43:55 -0700
Message-ID: <bf46380704041343i3a715cf3l5f7d4247882ab651@mail.gmail.com>

On 4/4/07, laura pena <lizzpenaorclgrp_at_yahoo.com> wrote:
>
> 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
>

Have you tried it?

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 04 2007 - 15:43:55 CDT

This message: [ Message body ]
Next message: Kerber, Andrew W.: "Strange Error"
Previous message: Mladen Gogala: "Re: oracle redhat 5 certification?"
In reply to: laura pena: "using set role command in a logon trigger"
Next in thread: laura pena: "Re: using set role command in a logon trigger"
Reply: laura pena: "Re: using set role command in a logon trigger"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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