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