RE: Re: Debug menu options and bug symbol are disabled or grayed out
Bert Scalzo <[email protected]> Wed, 27 Mar 2013 16:45:49 +0000
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <228D4BD15697E04CAF6CD482362F2ACE1399EA5F@ALVMBXW02.prod.quest.corp> |
--_000_228D4BD15697E04CAF6CD482362F2ACE1399EA5FALVMBXW02prodqu_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable You have not replied to any of my points - are you 100% sure both users wer= e granted connect debug session as I asked ??? From: [email protected] [mailto:[email protected]] On Behalf Of linor= chid Sent: Wednesday, March 27, 2013 11:34 AM To: [email protected] Subject: [toad] Re: Debug menu options and bug symbol are disabled or graye= d out I am using Toad 11.5. Yes, I have read Toad Advisor and Knowledge Artice 99= 59 in the knowledge base of quest support one by one. But so far, nothing h= as helped. Thanks. --- In [email protected]<mailto:toad%40yahoogroups.com>, Gregory Liss <g= regory.liss@...<mailto:gregory.liss@...>> wrote: > > What version of Toad are you on? Also, have you looked in Toad Advisor (h= elp -> Toad Advisor) to see if there is any issue with your debug privilege= s? > > Greg > > -----Original Message----- > 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 9: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. > > > > ------------------------------------ > > Yahoo! Groups Links > --_000_228D4BD15697E04CAF6CD482362F2ACE1399EA5FALVMBXW02prodqu_ 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","serif";} 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:1647471904; mso-list-template-ids:1867413960;} @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">You have not replied to any of my points – are you 100% sure both users were granted connect debug session as I asked ???<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 11:34 AM<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">I am using Toad 11.5. Yes, I have read Toad Advisor and Knowledge Artice 9959 in the knowledge base of quest support one by one. But so far, nothing has helped. Thanks.<br> <br> --- In <a href="mailto:toad%40yahoogroups.com">[email protected]</a>, Gregory Liss <<a href="mailto:gregory.liss@...">gregory.liss@...</a>> wrote:<br> ><br> > What version of Toad are you on? Also, have you looked in Toad Advisor (help -> Toad Advisor) to see if there is any issue with your debug privileges? <br> > <br> > Greg<br> > <br> > -----Original Message-----<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 9: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> > 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> > <br> > <br> > <br> > ------------------------------------<br> > <br> > Yahoo! Groups Links<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=58454/stime=1364402766" 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=X3oDMTJmNmNnNGltBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEzNjQ0MDI3NjY-">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=X3oDMTJkYjFnbGZ0BF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMzY0NDAyNzY2"> 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_228D4BD15697E04CAF6CD482362F2ACE1399EA5FALVMBXW02prodqu_--