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_at_24.12.106.199>
Date: Wed, 15 Aug 2001 22:27:54 GMT
Message-ID: <Xns90FEBBC0B95F7dbabobyahoocom_at_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.comReceived on Thu Aug 16 2001 - 00:27:54 CEST