Re: drop package. Where are the grants ?

From: Gokul <gokulkumar.gopal_at_gmail.com>
Date: Sat, 21 Mar 2009 09:37:32 -0700 (PDT)
Message-ID: <174210be-d0d9-4ecf-9988-4e761032414f_at_b16g2000yqb.googlegroups.com>



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

sqlplus ua_system_app_at_sdd1cmtu

SQL*Plus: Release 10.2.0.3.0 - 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 10.2.0.3.0 - 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