Home » SQL & PL/SQL » SQL & PL/SQL » privileges on Packages.
privileges on Packages. [message #35605] Sun, 30 September 2001 22:27 Go to next message
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 Go to previous message
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

----------------------------------------------------------------------
Previous Topic: plsql table check for double values
Next Topic: oracle Error
Goto Forum:
  


Current Time: Sat May 25 04:06:12 CDT 2024