Hello,
I know I've been going on about this enhancement request for quite some
years now, but if there is any justice in the world then it has to be
coming
up in the next version(s) of Rdb. With that in mind, please let me advise
that you may wish to provide a API call (with/without the SQL syntax) to
switch session authorization on a persona basis. Why? Because it could be
quite valid to switch authorization to an EXEC mode person, but without
the
process going into inner mode how can you tell if this was legitimate?
You *could* have SQL> set session authorization 'persona current';
Rdb would then do a $persona_query on the current *zero* persona. (Who
cares
what mode it is? It's current so it must be ok)
Anyway, If by the odd chance, you are implementing this and you plan on
banning non-user-mode personae then please think again.
Cheers Richard Maher