Re: DBA trigger view problem

"Tom" <cmc3232_at_yahoo.com> wrote in message news:S9t37.36317$gb6.4188463_at_news20.bellglobal.com...
> I have an user account have read access to dba_triggers table from
 SQLplus.
> However, try to compile a package with a function using the same select
> statement that I use in SQLplus. It gave an error.
>
> Her is the finding:
>
> SQL> select * from all_objects where object_name ='DBA_TRIGGERS';
>
> OWNER OBJECT_NAME OBJECT_ID OBJECT_TYPE CREATED
> LAST_DDL_
> ---------- ------------------------------ ---------- ------------ --------
 -
> ---------
> SYS DBA_TRIGGERS 799 VIEW
 13-OCT-99
> 13-OCT-99
> PUBLIC DBA_TRIGGERS 800 SYNONYM
 13-OCT-99
> 13-OCT-99
> SYSTEM DBA_TRIGGERS 1043 SYNONYM
 13-OCT-99
> 13-OCT-99
>
> SQL> @util.sql
> Package created.
> No errors.
> Warning: Package Body created with compilation errors.
> Errors for PACKAGE BODY UTIL:
>
> LINE/COL ERROR
> -------- -----------------------------------------------------------------
> 494/7 PL/SQL: SQL Statement ignored
> 495/12 PLS-00201: identifier 'SYS.DBA_TRIGGERS' must be declared
> SQL>
>
> Here is the statement:
>
> SELECT table_name into tmp_tab_cnt
> FROM dba_triggers
> WHERE table_name = tabname
> AND trigger_name like '%_EPPG_AI%'
> ;
>
> What has clobber up ? The View owed by SYSTEM, the synonym owned by
 PUBLIC
> ?
>
> Thanks for any help.
>
>
>

No version specified (why is that so difficult?) but the problem is well known
You have privilege to a role and roles are disabled during compilation of pl/sql
either get direct privilege or run (8i and higher) the procedure with invokers rights.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Sat Jul 21 2001 - 16:35:06 CDT