Monday, August 11, 2008

Toad: Debug menu grayed out (cannot debug any procedure)

Even if you have Toad XPert Edition or Toad with DBA Module, I sometime find the debug menu grayed out. Even If I create a new proceudre, It's still grayed out. If you get this issue, try the following and reconnect.

Issue Debug Connect Sesstion to your user as SYS or System.

Grant DEBUG CONNECT SESSION TO schema_owner

Replace Schema_Owner with your user name.

Log out and Log back in, Now Toad Debug menu will be available.

Another workaround is to give DBA Privs which is not recommended.

No comments:

Post a Comment