| privileges on Packages. [message #35605] |
Sun, 30 September 2001 22:27  |
sunil s.
Messages: 1
Registered: September 2001
|
Junior Member |
|
|
hi,
HOW to find out the whether a particular user has a execute permission on package or not.
----------------------------------------------------------------------
|
|
|
|
| Re: privileges on Packages. [message #35609 is a reply to message #35605] |
Mon, 01 October 2001 05:05  |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
select count(*) from all_objects where objectname='MYPACKAGENAME'
if above query returns more than zero means you have execute privilege on that package.
SURESH
----------------------------------------------------------------------
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
