Re: Value returned from user function

Peter,
Thanks for your input - interestingly we'd also come up with a similar approach to that you describe, if overriding 'user' or changing what it returns isn't feasible.
It'll be a reasonable fallback if there's no alternative, but the impact will be some rather widespread code changes that (of course!) we're trying to avoid...
Alan
>
>
> Create a Database package with a variable in the header.
> Create a procedure in the body of the package to set this variable
 e.g.
> set_my_user (my_choice_of_user_name varchar2)
> Create a function e.g. my_user to retrieve the variable. Call the
> set_my_user procedure at the start of the users session. Once set this
> variable will be retained for the duration of the users session.
>
> Good luck,
>
> Peter McKenzie
>
> In article <8fsf20$4mq$1_at_nnrp1.deja.com>,
> alanpol_at_my-deja.com wrote:
> > For the duration of a session, we'd like to get 'user' to return a
> > specific string which is not the actual username...>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed May 17 2000 - 00:00:00 CDT