Re: User Proxies

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 17 Jan 2000 08:36:30 -0500
Message-ID: <ll668s8tb19k5ubf4j9g69kkutf2norlit@4ax.com>

A copy of this was sent to John Alfieri <john.alfieri_at_worldnet.att.net> (if that email address didn't require changing) On Sat, 15 Jan 2000 21:58:39 -0500, you wrote:

>I have read that in 8.1 you can create user proxies with the alter user
>command. It sounds like purpose is to enable the middle tier to act as
>if it were a given user when executing DML. Unfortunately.. I'm not
>certain this is the case and the doc doesn't provide an adequate
>explanation. Can some one help with an explanation or example, as this
>sounds very useful for my current project.

see

http://osi.oracle.com/~tkyte/Misc/OCI-N-Tier.html

for info.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Jan 17 2000 - 07:36:30 CST