Package Access [message #41279] |
Fri, 13 December 2002 05:10 |
Keshav Tripathy
Messages: 30 Registered: November 2001
|
Member |
|
|
Suppose there is a package and we want to do some modification in that but I want to know who all are the users accessing that package.This information I require to know that what impact it will make to others.
Is there any way to know the history users of that package?
|
|
|
Re: Package Access [message #41282 is a reply to message #41279] |
Fri, 13 December 2002 14:04 |
vinay
Messages: 27 Registered: December 1999
|
Junior Member |
|
|
Hi,
Take a look at the follwing table and try to issue the following query by providing the package name.
TABLE NAME: ALL_DEPENDENCIES
QUERY:
select OWNER, NAME, TYPE, REFERENCED_OWNER, REFERENCED_NAME, REFERENCED_TYPE from all_dependencies where
name = 'NAME_OF_THE_PACKAGE';
Hope this will solve U'r prob'
Vinay
|
|
|