Re: drop package. Where are the grants ?
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 21 Mar 2009 16:39:48 +0100
Message-ID: <49c50a45$0$14977$426a74cc_at_news.free.fr>
Date: Sat, 21 Mar 2009 16:39:48 +0100
Message-ID: <49c50a45$0$14977$426a74cc_at_news.free.fr>
"Gokul" <gokulkumar.gopal_at_gmail.com> a écrit dans le message de news:
782268ec-c2a5-492c-87fe-f250f646ab55_at_a12g2000yqm.googlegroups.com...
| From some tests, I understand that when a package is dropped and
| recreated, the grants need not be given again.
|
This is wrong, when you drop a package all grants are dropped at the same time and your test clearly shows it.
| I don't see those grants in the dictionary tables, but the package
| executes fines from ua_system_app user. Am I missing something ?
Nothing in your post proves what you say. It may have "execute any procedure" privilege.
Regards
Michel
Received on Sat Mar 21 2009 - 10:39:48 CDT