Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Grant all question

Re: Grant all question

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Wed, 19 Jul 2006 01:58:20 -0400
Message-Id: <1153288700l.3492l.0l@medo.noip.com>

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-l
Received on Wed Jul 19 2006 - 00:58:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US