Re: RdbSQL> set session authorisation 'persona :ws_integer';
by "Dr. Dweeb" <NOSPAM_5msg0h202@[EMAIL PROTECTED]
>
Jun 17, 2005 at 10:38 PM
Try comp.database.rdb or the oraclerdb mailing list at jcc.com or the
Oracle
Enhancement Request system - the Rdb engineers definitely read one or more
of these.
Dr. Dweeb.
Richard Maher wrote:
> 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