Re: Debug menu options and bug symbol are disabled or grayed out

Thanks for the information.

--- In [email protected], Gregory Liss <gregory.liss@...> wrote:
>
> Here are abbreviated queries we use to determine if the debug symbols are grayed out.
> 
> SELECT SUM (DECODE (Privilege, 'DEBUG CONNECT SESSION', 1, 0))
>           debug_connect_session
>   FROM sys.session_privs
>  WHERE privilege = 'DEBUG CONNECT SESSION';
> 
> and 
> 
> SELECT SUM (DECODE (object_name, 'DBMS_DEBUG', 1, 0)) dbg
>   FROM sys.all_objects  -- can be sys.dba_objects as well
>  WHERE     owner = 'SYS'
>        AND object_type = 'PACKAGE'
>        AND object_name = 'DBMS_DEBUG';
> 
> Both of them have to return 1 in order to have the debugger enabled.
> 
> Greg
> 
> 
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of linorchid
> Sent: Wednesday, March 27, 2013 12:34 PM
> To: [email protected]
> Subject: [toad] Re: Debug menu options and bug symbol are disabled or grayed out
> 
> 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.
> 
> --- In [email protected], Gregory Liss <gregory.liss@> wrote:
> >
> > 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?  
> > 
> > Greg
> > 
> > -----Original Message-----
> > From: [email protected] [mailto:[email protected]] On Behalf Of linorchid
> > Sent: Tuesday, March 26, 2013 9:56 PM
> > To: [email protected]
> > 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 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.  
> > 
> > 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.
> > 
> > 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???
> > 
> > Any help, advice or suggestions would be greatly appreciated.  
> > 
> > Thanks.
> > 
> > 
> > 
> > ------------------------------------
> > 
> > Yahoo! Groups Links
> >
> 
> 
> 
> 
> ------------------------------------
> 
> Yahoo! Groups Links
>




------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/