Can a stored procedure change his own profile ?

From: <sj_at_china.pages.com.cn>
Date: Fri, 21 Aug 1998 08:26:01 GMT
Message-ID: <6rjaun$mp7$1@nnrp1.dejanews.com>

Hello sir :

I am facing such a problem :

Generally , Oracle PL/SQL procedure is stored under a special schema and can just manipulate the data under that schema . But if it need to manipulate the data under another schema , the general solution is to allow the user which own the procedure to manipulte the data under another schema . But this is not allowed , can the procedure itself change its own schema automatically in the process of execution ?

if possible , how to do it ? is it need to store the username/password parir in the procedure , can it be dynamically assigned ?

Thanks in advance . Each word will be highly appriciated !

Best Regards

Jing Shen

Mail to : sj_at_china.pages.com.cn

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Aug 21 1998 - 03:26:01 CDT