Re: Check session role form trg/proc

In article <48hnok$1s3_at_oslo-nntp.eunet.no>, rune_at_lis.pitt.edu (Rune Nygård) wrote:

> I can't figure out how to retrieve the session role from a
> trigger (or procedure).
> The SESSION_ROLES view gives zero rows back when i run it
> inside a trigger, but from sql*plus it works fine (of course)..
>

This may be related to the problem I had with not being able to use system privileges granted through roles. I was told that stored procedures can't use roles. Triggers are just another form of stored procedure.

-- 
Ed Bruce
edward_at_igate1.hac.com
Key fingerprint =  62 8D FC 8F 27 2F 89 D0  8B 38 7E 34 33 74 C2 36