OraFAQ Forum: Security » What system privillege

Home » RDBMS Server » Security » What system privillege (Oracle 10g ,Generic)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What system privillege [message #340544]

Wed, 13 August 2008 04:36

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

Report message to a moderator

Re: What system privillege [message #340562 is a reply to message #340544]

Wed, 13 August 2008 05:15

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No system privilege but an object one: execute on the package.

Regards
Michel

Report message to a moderator

Re: What system privillege [message #340569 is a reply to message #340544]

Wed, 13 August 2008 05:39

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 ?

Report message to a moderator

Re: What system privillege [message #340588 is a reply to message #340569]

Wed, 13 August 2008 06:18

Michel Cadot
Messages: 68418
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

Report message to a moderator

Previous Topic:	Wanna help please
Next Topic:	license information

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 26 04:04:50 CDT 2023