Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Error when running DBMS_DDL.ANALYZE_OBJECT in PL/SQL package
"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 Wed Aug 15 2001 - 17:27:54 CDT
![]() |
![]() |