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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Grant command questions

Re: Grant command questions

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Tue, 28 Mar 2006 17:59:06 -0400
Message-ID: <cd4305c10603281359o1d7227dcuf03138bc3d415469@mail.gmail.com>


Hi,
No you can't, to create a function on user2 doing a select on a table on user1, you have to do a grant from user1 to user for that object, the only thing you can save time is giving all the privileges.

But, you can create a procedure to do all privileges from user 1 to user2, didn't give yet, doing a query on dictionary views

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 28 2006 - 15:59:06 CST

Original text of this message

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