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$>

"Gokul" <> a écrit dans le message de news:
| 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.

Michel Received on Sat Mar 21 2009 - 10:39:48 CDT

Original text of this message