It is possible to restrict the debugging in Sybase Central to one user.

What I am looking for, to use it on a productive system, is to restrict the debugging just to one connection. Is that possible? I am looking for a way to debug only the procedures called by a single connection ignoring all calls to these procedures which come from other connections.

asked 20 Jun '12, 10:37

Martin's gravatar image

Martin
8.6k116151237
accept rate: 14%

edited 21 Jun '12, 03:36


To use the debugger requires either DBA privilege or SA_DEBUG authority, which is how you would restrict the set of users who can use the debugger.

There is no built-in mechanism to limit debugger connections that I am aware of. You could use the IsDebugger connection property to test to see if another connection is already using the debugger - for example, you could execute an event periodically to see if more than one such connection exists, and then report the existence of more than one connection as a message in the console window.

permanent link

answered 20 Jun '12, 15:46

Glenn%20Paulley's gravatar image

Glenn Paulley
10.7k571104
accept rate: 43%

Thanks for the answer, but I haven't meant a way to prevent multiple debugger sessions. I am looking for a way to debug only the procedures called by a single connection ignoring all calls to these procedures which come from other connections. Sorry for that.

(21 Jun '12, 03:35) Martin
Replies hidden
Comment Text Removed

Can you set a breakpoint &&SPID = n where n is the connection number?

http://dcx.sybase.com/index.html#1201/en/dbusage/editing-breakpoints-procdebug.html

(21 Jun '12, 03:53) Breck Carter
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×102

question asked: 20 Jun '12, 10:37

question was seen: 819 times

last updated: 21 Jun '12, 03:53