RE: Re: Debug menu options and bug symbol are disabled or grayed out
Bert Scalzo <[email protected]> Wed, 27 Mar 2013 17:19:26 +0000
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <228D4BD15697E04CAF6CD482362F2ACE1399EA88@ALVMBXW02.prod.quest.corp> |
--_000_228D4BD15697E04CAF6CD482362F2ACE1399EA88ALVMBXW02prodqu_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Great - glad I could help :) From: [email protected] [mailto:[email protected]] On Behalf Of linor= chid Sent: Wednesday, March 27, 2013 12:12 PM To: [email protected] Subject: [toad] Re: Debug menu options and bug symbol are disabled or graye= d out Pardon me Bert. I just read your response and your suggestion works. Cheers, you just made my day. Thanks millions. :) --- In [email protected]<mailto:toad%40yahoogroups.com>, Bert Scalzo <be= rt.scalzo@...<mailto:bert.scalzo@...>> wrote: > > You do NOT directly grant execute to sys.dbms_debug - there is a built in= Oracle priv that you grant: > > grant debug connect session to user; > > This works the same no matter whose PL/SQL debugger you use - this is an = Oracle thing, not a toad thing. > > > From: [email protected]<mailto:toad%40yahoogroups.com> [mailto:toad@ya= hoogroups.com<mailto:toad%40yahoogroups.com>] On Behalf Of linorchid > Sent: Tuesday, March 26, 2013 8:56 PM > To: [email protected]<mailto:toad%40yahoogroups.com> > Subject: [toad] Debug menu options and bug symbol are disabled or grayed = out > > > > I have two schemas in the same database instance. One of the schemas has = access to all bebug options under the 'Debug' menu, the debug symbol to tog= gle the debug option on/off on the tool bar and the Execute PL/SQL w/ Debug= ger option. But the other schema has no debug options under the 'Debug' men= u, the debug symbol to turn the debug option on/off on the tool bar is gray= ed out and the Execute PL/SQL w/ Debugger option is also grayed out. > > All the privileges for both users are identical. I have verified that the= DBMS_DEBUG package in the sys schema is valid. The Toad option settings in= Debugger and Execute/Compile for both users are about the same. Our DBA to= ld me that both users have been granted the 'execute' permission on sys.dbm= s_debug. > > What am I missing? If both users are granted to access sys.dbms_debug and= both have the same debug options setting, why one user has the debug privi= leges but not the other??? > > Any help, advice or suggestions would be greatly appreciated. > > Thanks. > --_000_228D4BD15697E04CAF6CD482362F2ACE1399EA88ALVMBXW02prodqu_ Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: 7bit <head> <style type="text/css"> <!-- /* start of attachment style */ .ygrp-photo-title{ clear: both; font-size: smaller; height: 15px; overflow: hidden; text-align: center; width: 75px; } div.ygrp-photo{ background-position: center; background-repeat: no-repeat; background-color: white; border: 1px solid black; height: 62px; width: 62px; } div.photo-title a, div.photo-title a:active, div.photo-title a:hover, div.photo-title a:visited { text-decoration: none; } div.attach-table div.attach-row { clear: both; } div.attach-table div.attach-row div { float: left; /* margin: 2px;*/ } p { clear: both; padding: 15px 0 3px 0; overflow: hidden; } div.ygrp-file { width: 30px; valign: middle; } div.attach-table div.attach-row div div a { text-decoration: none; } div.attach-table div.attach-row div div span { font-weight: normal; } div.ygrp-file-title { font-weight: bold; } /* end of attachment style */ --> </style> </head> <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii"> <meta name="Generator" content="Microsoft Word 14 (filtered medium)"> <!--[if !mso]><style>v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style><![endif]--><style><!-- /* Font Definitions */ @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} @font-face {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} @font-face {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman","serif";} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:purple; text-decoration:underline;} p {mso-style-priority:99; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} code {mso-style-priority:99; font-family:"Courier New";} pre {mso-style-priority:99; mso-style-link:"HTML Preformatted Char"; margin:0in; margin-bottom:.0001pt; font-size:10.0pt; font-family:"Courier New";} tt {mso-style-priority:99; font-family:"Courier New";} span.cat {mso-style-name:cat;} span.ct {mso-style-name:ct;} span.HTMLPreformattedChar {mso-style-name:"HTML Preformatted Char"; mso-style-priority:99; mso-style-link:"HTML Preformatted"; font-family:Consolas;} p.attach, li.attach, div.attach {mso-style-name:attach; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:9.0pt; font-family:"Arial","sans-serif";} p.bold, li.bold, div.bold {mso-style-name:bold; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:10.0pt; font-family:"Arial","sans-serif"; font-weight:bold;} p.green, li.green, div.green {mso-style-name:green; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif"; color:#628C2A;} p.replbq, li.replbq, div.replbq {mso-style-name:replbq; margin:3.0pt; font-size:12.0pt; font-family:"Times New Roman","serif";} p.ad, li.ad, div.ad {mso-style-name:ad; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} p.underline, li.underline, div.underline {mso-style-name:underline; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} span.yshortcuts {mso-style-name:yshortcuts;} p.ad1, li.ad1, div.ad1 {mso-style-name:ad1; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} p.ad2, li.ad2, div.ad2 {mso-style-name:ad2; mso-margin-top-alt:auto; margin-right:0in; margin-bottom:7.5pt; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} p.underline1, li.underline1, div.underline1 {mso-style-name:underline1; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif"; text-decoration:underline;} span.yshortcuts1 {mso-style-name:yshortcuts1; font-family:"Verdana","sans-serif"; font-weight:bold;} span.yshortcuts2 {mso-style-name:yshortcuts2; font-family:"Verdana","sans-serif"; font-weight:normal;} span.EmailStyle36 {mso-style-type:personal-reply; font-family:"Calibri","sans-serif"; color:#1F497D;} .MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in;} div.WordSection1 {page:WordSection1;} /* List Definitions */ @list l0 {mso-list-id:1165316207; mso-list-template-ids:288265746;} @list l0:level1 {mso-level-number-format:bullet; mso-level-text:\F0B7; mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Symbol;} @list l0:level2 {mso-level-number-format:bullet; mso-level-text:o; mso-level-tab-stop:1.0in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:"Courier New"; mso-bidi-font-family:"Times New Roman";} @list l0:level3 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:1.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level4 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:2.0in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level5 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:2.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level6 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:3.0in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level7 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:3.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level8 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:4.0in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level9 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:4.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} ol {margin-bottom:0in;} ul {margin-bottom:0in;} --></style><!--[if gte mso 9]><xml> <o:shapedefaults v:ext="edit" spidmax="1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext="edit"> <o:idmap v:ext="edit" data="1" /> </o:shapelayout></xml><![endif]--> </head> <body bgcolor="white" lang="EN-US" link="blue" vlink="purple"> <div class="WordSection1"> <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Great – glad I could help </span><span style="font-size:11.0pt;font-family:Wingdings;color:#1F497D">J</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p></o:p></span></p> <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p> <div> <div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in"> <p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> [email protected] [mailto:[email protected]] <b>On Behalf Of </b>linorchid<br> <b>Sent:</b> Wednesday, March 27, 2013 12:12 PM<br> <b>To:</b> [email protected]<br> <b>Subject:</b> [toad] Re: Debug menu options and bug symbol are disabled or grayed out<o:p></o:p></span></p> </div> </div> <p class="MsoNormal"><o:p> </o:p></p> <p class="MsoNormal"> <o:p></o:p></p> <div id="ygrp-mlmsg"> <div id="ygrp-msg"> <div id="ygrp-text"> <p style="margin-bottom:12.0pt"><br> <br> Pardon me Bert. I just read your response and your suggestion works. <br> <br> Cheers, you just made my day. <br> <br> Thanks millions. :)<br> <br> --- In <a href="mailto:toad%40yahoogroups.com">[email protected]</a>, Bert Scalzo <<a href="mailto:bert.scalzo@...">bert.scalzo@...</a>> wrote:<br> ><br> > You do NOT directly grant execute to sys.dbms_debug - there is a built in Oracle priv that you grant:<br> > <br> > grant debug connect session to user;<br> > <br> > This works the same no matter whose PL/SQL debugger you use - this is an Oracle thing, not a toad thing.<br> > <br> > <br> > From: <a href="mailto:toad%40yahoogroups.com">[email protected]</a> [mailto:<a href="mailto:toad%40yahoogroups.com">[email protected]</a>] On Behalf Of linorchid<br> > Sent: Tuesday, March 26, 2013 8:56 PM<br> > To: <a href="mailto:toad%40yahoogroups.com">[email protected]</a><br> > Subject: [toad] Debug menu options and bug symbol are disabled or grayed out<br> > <br> > <br> > <br> > I have two schemas in the same database instance. One of the schemas has access to all bebug options under the 'Debug' menu, the debug symbol to toggle the debug option on/off on the tool bar and the Execute PL/SQL w/ Debugger option. But the other schema has no debug options under the 'Debug' menu, the debug symbol to turn the debug option on/off on the tool bar is grayed out and the Execute PL/SQL w/ Debugger option is also grayed out.<br> > <br> > All the privileges for both users are identical. I have verified that the DBMS_DEBUG package in the sys schema is valid. The Toad option settings in Debugger and Execute/Compile for both users are about the same. Our DBA told me that both users have been granted the 'execute' permission on sys.dbms_debug.<br> > <br> > What am I missing? If both users are granted to access sys.dbms_debug and both have the same debug options setting, why one user has the debug privileges but not the other???<br> > <br> > Any help, advice or suggestions would be greatly appreciated.<br> > <br> > Thanks.<br> ><o:p></o:p></p> </div> <div> <p class="MsoNormal"><span style="color:white"><o:p></o:p></span></p> </div> </div> <!-- |**|begin egp html banner|**| --> <br> <br> <!-- |**|end egp html banner|**| --> <div width="1" style="color: white; clear: both;"/>__._,_.___</div> <!-- Start Recommendations --> <!-- End Recommendations --> <!-- |**|begin egp html banner|**| --> <img src="http://geo.yahoo.com/serv?s=97476590/grpId=1103546/grpspId=1705115368/msgId=58457/stime=1364404772" width="1" height="1"> <br> <!-- |**|end egp html banner|**| --> <!-- |**|begin egp html banner|**| --> <br> <div style="font-family: verdana; font-size: 77%; border-top: 1px solid #666; padding: 5px 0;" > Your email settings: Individual Email|Traditional <br> <a href="http://groups.yahoo.com/group/toad/join;_ylc=X3oDMTJmNHEzYTA2BF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEzNjQ0MDQ3NzI-">Change settings via the Web</a> (Yahoo! ID required) <br> Change settings via email: <a href="mailto:[email protected]?subject=Email Delivery: Digest">Switch delivery to Daily Digest</a> | <a href = "mailto:[email protected]?subject=Change Delivery Format: Fully Featured">Switch to Fully Featured</a> <br> <a href="http://groups.yahoo.com/group/toad;_ylc=X3oDMTJkYWNrNmExBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMzY0NDA0Nzcy"> Visit Your Group </a> | <a href="http://docs.yahoo.com/info/terms/"> Yahoo! Groups Terms of Use </a> | <a href="mailto:[email protected]?subject=Unsubscribe"> Unsubscribe </a> <br> </div> <br> <!-- |**|end egp html banner|**| --> <div style="color: white; clear: both;"/>__,_._,___</div> </body> </html> --_000_228D4BD15697E04CAF6CD482362F2ACE1399EA88ALVMBXW02prodqu_--