Re: Grant command questions

  • From: "Juan Carlos Reyes Pacheco" <juancarlosreyesp@xxxxxxxxx>
  • To: Harvinder.Singh@xxxxxxxxxxxxx
  • Date: Tue, 28 Mar 2006 17:59:06 -0400

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: