Re: Grant command questions

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