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)..
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