Exception when viewing SQL Server function or stored procedure

I've been getting exceptions on the Function Editor tab (eg. "com.onseven.dbvis.G.B.L: Function schema.fn_xxx does not exist") when attempting to browse functions or stored procedures in a particular MS SQL Server 2005 database. I could see the name of the function in the object tree, but not view the underlying code in the Function Editor. Further testing revealed that the account I was using had only execute privileges on the DB objects in question; when using an admin level account I experienced no problems. It seems to me, though, that if the user account in use does not have sufficient privileges to view the text of a function or stored procedure, that they should be presented with a warning message to that effect, not the Debug Window with an exception.

Hi Roger, I've pasted a copy below of the exception that I see in the Debug Window when I click on the function in the object tree. ----- Debug Printouts ----- com.onseven.dbvis.G.B.L: Function dbo.fn_ClipTime does not exist at com.onseven.dbvis.S.A.F.?(Z:2062) at com.onseven.dbvis.b.B.A.A.K.?(Z:3544) at com.onseven.dbvis.b.B.A.A.J.?(Z:1314) at com.onseven.dbvis.b.B.E.?(Z:3046) at com.onseven.dbvis.b.B.E.?(Z:3195) at com.onseven.dbvis.b.B.E.?(Z:759) at com.onseven.dbvis.b.B.E$1.ancestorAdded(Z:1320) at javax.swing.AncestorNotifier.fireAncestorAdded(Unknown Source) at javax.swing.AncestorNotifier.componentShown(Unknown Source) at java.awt.Component.processComponentEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at com.onseven.dbvis.J.A.g.dispatchEvent(Z:2143) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source)

Hi Steve, We have changed the behavior for this case so that no output is written to the debug window. Instead a "source not available" message is shown in the Procedure Editor footer. This change will be part of the next maintenance release, 6.5.5. Best Regards, Hans

> {quote:title=Hans Bergsten wrote:}{quote} > We have changed the behavior for this case so that no output is written to the debug window. Instead a "source not available" message is shown in the Procedure Editor footer. This change will be part of the next maintenance release, 6.5.5. Sounds good. Thanks.

Yes, that's better, though I might have suggested putting the "Source code is not available" message in the Procedure/Function Editor area rather than in the status bar (since that's where the user's focus is). Also, I've noticed that the "not available" message text is usually but not always in red, although I've been unable to reproduce this consistently. Thanks for making the change.