Re: Packages [message #39830] |
Wed, 14 August 2002 12:32 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
Yes, if user B has been granted execute on the package in A, user B can access it. If there is no synonym for the package, user B will need to reference the package as a.package_name.
If changes are made to the package, user B will still be able to access the package as long as the changes were made with 'create or replace package' (which retains the grants). If the package is ever dropped and recreated, the grant will need to be reapplied.
I'm not sure what you mean by "what if they are in the same schema."
|
|
|