Debug menu options and bug symbol are disabled or grayed out

Discussion:

linorchid

2013-03-27 01:55:44 UTC

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

<*> 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:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

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

Bert Scalzo

2013-03-27 11:33:21 UTC

Permalink

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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of linorchid
Sent: Tuesday, March 26, 2013 8:56 PM
To: ***@yahoogroups.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 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.

linorchid

2013-03-27 17:11:50 UTC

Permalink

Pardon me Bert. I just read your response and your suggestion works.

Cheers, you just made my day.

Thanks millions. :)

Post by Bert Scalzo
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.
Sent: Tuesday, March 26, 2013 8:56 PM
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

<*> 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:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

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

Bert Scalzo

2013-03-27 17:19:26 UTC

Permalink

Great - glad I could help :)

From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of linorchid
Sent: Wednesday, March 27, 2013 12:12 PM
To: ***@yahoogroups.com
Subject: [toad] Re: Debug menu options and bug symbol are disabled or grayed out

Pardon me Bert. I just read your response and your suggestion works.

Cheers, you just made my day.

Thanks millions. :)

Gregory Liss

2013-03-27 11:48:41 UTC

Permalink

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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of linorchid
Sent: Tuesday, March 26, 2013 9:56 PM
To: ***@yahoogroups.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 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

<*> 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:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

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

linorchid

2013-03-27 16:34:02 UTC

Permalink

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.

Post by Gregory Liss
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-----
Sent: Tuesday, March 26, 2013 9:56 PM
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

Bert Scalzo

2013-03-27 16:45:49 UTC

Permalink

You have not replied to any of my points - are you 100% sure both users were granted connect debug session as I asked ???

From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of linorchid
Sent: Wednesday, March 27, 2013 11:34 AM
To: ***@yahoogroups.com
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.

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-----
Sent: Tuesday, March 26, 2013 9:56 PM
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

Gregory Liss

2013-03-27 17:09:04 UTC

Permalink

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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of linorchid
Sent: Wednesday, March 27, 2013 12:34 PM
To: ***@yahoogroups.com
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.

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

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:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

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

linorchid

2013-03-27 17:34:27 UTC

Permalink

Thanks for the information.

Post by Gregory Liss
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-----
Sent: Wednesday, March 27, 2013 12:34 PM
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.

------------------------------------
Yahoo! Groups Links

G***@aigfpc.com

2013-04-01 21:18:23 UTC

Permalink

It has come to my attention that there is a serious issue with version 11.6 (both 11.6.0.43 and 11.6.1.6).
Here is the scenario:
1. A user runs a query (for example select * from dual;)
2. clicks on "+" to open another Tab - TOAD blows up.
3. The same behavior is for all read-only users of 11.6 (works fine on 11.5)
4. Read-Write users have no such a problem

This is a Call Stack:

Here is general info:

Before I call support, maybe it is a know issue?

Many thanks,
George

________________________________

G***@aigfpc.com

2013-04-11 17:55:26 UTC

Permalink

Michael,

Many thanks for your suggestion. I used #3 and it worked perfectly.

George

From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of Michael Staszewski
Sent: Friday, April 05, 2013 9:32 AM
To: ***@yahoogroups.com
Subject: RE: [toad] Read-Only TOAD 11.6 blows up

This should be fixed. I cannot reproduce it in the current source when building a readonly executable. In Toad 11.6 there are multiple ways to have readonly Toad.

1. Readonly install
2. Readonly property per connection (set on login window)
3. With Toad closed, backup Toad.lic (in installation folder) and rename readonly.lic to Toad.lic

Using options 2 and 3 I cannot reproduce in 11.6 so perhaps one of those could be a workaround.

Michael

From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of ***@aigfpc.com
Sent: Monday, April 01, 2013 5:18 PM
To: ***@yahoogroups.com
Subject: [toad] Read-Only TOAD 11.6 blows up [1 Attachment]

[Attachment(s) from ***@aigfpc.com<mailto:***@aigfpc.com> included below]

It has come to my attention that there is a serious issue with version 11.6 (both 11.6.0.43 and 11.6.1.6).
Here is the scenario:
1. A user runs a query (for example select * from dual;)
2. clicks on "+" to open another Tab - TOAD blows up.
3. The same behavior is for all read-only users of 11.6 (works fine on 11.5)
4. Read-Write users have no such a problem

This is a Call Stack:

[cid:***@01CE36B9.F2C50190]
Here is general info:

Before I call support, maybe it is a know issue?

Many thanks,
George

________________________________

Attachment(s) from ***@aigfpc.com<mailto:***@aigfpc.com>

1 of 1 File(s)
[cid:~WRD000.jpg]
general.txt<http://xa.yimg.com/kq/groups/1103546/1054806036/name/general%2Etxt>

________________________________