Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Grant all question
On 07/19/2006 01:46:29 AM, Sinardy Xing wrote:
> to use this method we can use dba_objects right to include procedures,
> functions and others?, I just checking wheather 10g got one command only, I
> need to prepare like 20 users like B. :)
Definitely not. Query against ALL_OBJECTS is illegal and running this query against all objects is a major felony.
-- Mladen Gogala http://www.mgogala.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 19 2006 - 00:58:20 CDT