Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Can a stored procedure change his own profile ?

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US