OraFAQ Forum: Security » DEBUG ANY PROCEDURE

Home » RDBMS Server » Security » DEBUG ANY PROCEDURE (DB12.1.0.2)

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

DEBUG ANY PROCEDURE [message #657812]

Wed, 23 November 2016 07:40

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

A developer has asked me to grant him DEBUG CONNECT SESSION and DEBUG ANY PROCEDURE so that he can use DBMS_DEBUG_JDWP. I'm not familiar with this, and what concerns me is security. Would I be giving the developer access to all the code in the database? Or is there any other risk? There is no privilege DEBUG PROCEDURE.

Thank you for any insight.

[Edit MC: fix title typo]

[Updated on: Wed, 23 November 2016 10:10] by Moderator

Report message to a moderator

Re: DBBUG ANY PROCEDURE [message #657813 is a reply to message #657812]

Wed, 23 November 2016 07:57

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Well, I'm probably not the best person to answer this. Anyway: in order to use TOAD debugger, one has to have granted the following privileges:
- execute on dbms_debug
- debug any procedure
- debug connect session
Therefore, I'd say that developer knows what he needs.

Besides, that's what I granted myself (when I had a database and SYS password), but I didn't check whether I have access to ALL the code, so ...

Report message to a moderator

Re: DBBUG ANY PROCEDURE [message #657815 is a reply to message #657812]

Wed, 23 November 2016 08:36

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

As long as it is only on a Dev system I'd have no issue, personally.

Report message to a moderator

Re: DBBUG ANY PROCEDURE [message #657816 is a reply to message #657812]

Wed, 23 November 2016 08:36

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, DEBUG ANY PROCEDURE gives access to all stored code, give DEBUG on the procedure/package/type/Java source/... user actually needs to debug.

Report message to a moderator

Re: DBBUG ANY PROCEDURE [message #657817 is a reply to message #657815]

Wed, 23 November 2016 08:37

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

The trouble is that there are several customers hosted in the same dev database: there each have their own schema.

Report message to a moderator

Re: DBBUG ANY PROCEDURE [message #657818 is a reply to message #657813]

Wed, 23 November 2016 08:39

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Thank you for replying, actually I can't make it work anyway. Bizarre errors to do with networking. It's an AWS instance which complicates everything.

Report message to a moderator

Re: DBBUG ANY PROCEDURE [message #657819 is a reply to message #657816]

Wed, 23 November 2016 08:39

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Right, that is what I was worried about. Thankyou.

Report message to a moderator

Re: DBBUG ANY PROCEDURE [message #657820 is a reply to message #657817]

Wed, 23 November 2016 08:39

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Ah, in that case I'd be wary. I'd go with Michel's solution.

Or Oracle 12c Wink

Report message to a moderator

Re: DBBUG ANY PROCEDURE [message #657821 is a reply to message #657817]

Wed, 23 November 2016 08:41

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

So knock up a little dynamic SQL script to grant the developer debug on every procedure belonging to the appropriate schema.

Report message to a moderator

Re: DBBUG ANY PROCEDURE [message #657822 is a reply to message #657821]

Wed, 23 November 2016 08:47

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Well, possibly.
Thank you everyone.

Report message to a moderator

Previous Topic:	Prevent any query that makes simultaneous references to mutually exclusive columns.
Next Topic:	connecting sqlplus without password

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 18:44:54 CDT 2025