Home » RDBMS Server » Security » What system privillege (Oracle 10g ,Generic)
What system privillege [message #340544] Wed, 13 August 2008 04:36 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
What system privilege let you execute system packages(Oracle supplied packages) .

Thanks
Re: What system privillege [message #340562 is a reply to message #340544] Wed, 13 August 2008 05:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No system privilege but an object one: execute on the package.

Regards
Michel
Re: What system privillege [message #340569 is a reply to message #340544] Wed, 13 August 2008 05:39 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Thanks mike,
i see one user able to execute dbms packages .
folowing are the roles user has .
CONNECT
RESOURCE
REPORT_USR
SELECT_CATALOG_ROLE

i have checked REPORT_USR role as well but donot see any execute privilege given on any package.Neithr it is given explicitly. how this is possible any idea ?
Re: What system privillege [message #340588 is a reply to message #340569] Wed, 13 August 2008 06:18 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i have checked REPORT_USR role

How did you check it?

Execute privilege on many standard packages has been granted to PUBLIC.

Regards
Michel
Previous Topic: Wanna help please
Next Topic: license information
Goto Forum:
  


Current Time: Fri Mar 29 10:35:37 CDT 2024