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_at_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_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------