Re: a bit tricky question

Mike wrote:
>
> Hello,
>
> This question is a bit tricky and to the compilance of sox. Thanks.
>
> I created a procedure under x schema in database A and want to execute
> it from database B under y schema.
>
> How to work it out without grant execute to public?
>
> Thanks in advance.
> Mike

On database A:

create a schema Y with same passwd as Y on database B
grant execute on X.PROC to Y;

On database B:

connect as Y
execute X.PROC@PUBLIC_LINK


--
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald@xxxxxxxxx


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------
.

Relevant Pages

  • Re: Java is becoming the new Cobol
    ... In the Unisys 2200 environment using their Network Database Server, you get a schema work area depending on how you invoke the schema. ... However, it not only copies the schema area into the program, but the "DMCA" (Database Management Communication Area - basically, the block of information that holds your connection state) is copied in too. ... So, you're left with working-storage, which makes it visible to your program only, or common-storage, which makes it visible to programs linked in. ...
    (comp.lang.cobol)
  • Split messages
    ... This is based off the northwind database. ... Create document schema: ... Select the SQL entry, make sure that we are pointing to the SQL ... For the item select a receive pipeline and name it EmpSplitPipe.btp. ...
    (microsoft.public.biztalk.general)
  • Re: Decouple SQL queries from class in OOP design
    ... > Of course there are existing applications that uses many different ... > architectures and still provides measurable business value. ... > should access every database directly. ... by the database, but the schema changes. ...
    (comp.object)
  • ANN: Sequel 2.8.0 Released
    ... Sequel provides thread safety, connection pooling and a concise DSL ... for constructing database queries and table schemas. ... if you want to, but the results and API are adapter dependent, ... Model associations, getting the schema, joins, and many other ...
    (comp.lang.ruby)
  • Re: personality test
    ... "Mike VB" wrote: ... I'm using dreamweaver to create my asp documents wiht vbscript. ... "Jim Carlock" a écrit dans le message de ... >>> database until you had a complete data set to save. ...
    (microsoft.public.vb.database)