Re: Grant all question

Just a bit sideways from the Q:
I would seriously question that approach and rather propose to follow
more minimalistic approach giving only grants that are needed.
In addition, there is no way to grant certain operations. For example,
in order to truncate the table, user must either own this table or
have DROP ANY TABLE privilege. Are you ready to grant DROP ANY TABLE?
;-) Of course, there is a workaround to write a PL/SQL procedure.


2006/7/19, Sinardy Xing <oracle.rdbms@xxxxxxxxx>:
 Something like this
 GRANT ALL OF a TO b;


--
Best regards,
Alex Gorbachev

http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l


Other related posts: