Re: drop package. Where are the grants ?

From: Gokul <>
Date: Sat, 21 Mar 2009 09:37:32 -0700 (PDT)
Message-ID: <>

I tried it again with a new session (all previous ones closed)..

sqlplus ua_system_app_at_sdd1cmtu

SQL*Plus: Release - Production on Sat Mar 21 17:34:06 2009

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

SQL> exec ua_system_tables.dummy_2.p(1);

PL/SQL procedure successfully completed.

SQL> select * from all_tab_privs where table_name = 'DUMMY_2';

no rows selected

SQL> select * from all_objects where object_name = 'DUMMY_2';

no rows selected

SQL> Rgds,
Gokul Received on Sat Mar 21 2009 - 11:37:32 CDT

Original text of this message