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

Home -> Community -> Usenet -> c.d.o.server -> Re: Error when running DBMS_DDL.ANALYZE_OBJECT in PL/SQL package

Re: Error when running DBMS_DDL.ANALYZE_OBJECT in PL/SQL package

From: Robert Fazio <dbabob_at_yahoo.nospam.com>
Date: Wed, 15 Aug 2001 22:27:54 GMT
Message-ID: <Xns90FEBBC0B95F7dbabobyahoocom@24.12.106.199>


"Gunawan, Raymond Suryodiono" <rgunawan_at_zsassociates.com> wrote in news:3B7AD61C.66CACBBB_at_zsassociates.com:

> dbms_ddl.analyze_object('TABLE', v_output_tablespace, v_just_table_name,
> 'COMPUTE');
In order to call a package through a package, you have to be granted access specifically. It can't be through a role. For example system can't select from dba_tables unless explicitly granted access to that view through a package.

-- 
Robert Fazio
Senior Technical Advisor
dbabob_at_yahoo.com
Received on Wed Aug 15 2001 - 17:27:54 CDT

Original text of this message

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