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

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL Procedure

Re: PL/SQL Procedure

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Sat, 24 Nov 2001 05:31:26 -0600
Message-ID: <tvv18do1r739bf@corp.supernews.com>


Yes,
but you need to have select authority granted explicitly to your userid (not through a role)

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http:///www.brainbench.com

"Craig Ballingall" <craig.ballingall_at_talk21nospam.com> wrote in message news:3bfe9494_2_at_mk-nntp-1.news.uk.worldonline.com...
> Is it possible to select from another users schema inside a stored
> procedure, if so can someone please tell me how
>
>
>
> Regards
>
> Craig
>
>
Received on Sat Nov 24 2001 - 05:31:26 CST

Original text of this message

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