Re: Dynamic Default Roles ?

Dennis Brewer (dbrewer_at_nosc.mil) wrote:
: Fact1: Every user that logs in is assigned a defult role.
: Fact2: Some users wear different hats when logging onto the database. This requires
: different role assignments bases on the current application and session.
: Fact3: Each time a user logs on a session is started with an entry in the v$session table.
 

: Question1: Does it put an entry in the v$session table, before the default role is enabled?
: Question2: Can a trigger be placed on the v$session table?

[snip]

Why couldn't the users be assigned all the roles they need as their default role? I don't quite understand the dilemma here.

Joe Nardone

--
                                   
=------------------------------------------------------------------------=
Joe Nardone               |    
joe_at_access.digex.net      |