HANA Artifacts Part3.1 (SQLScript Debugger SP7)

Please refer http://scn.sap.com/docs/DOC-48851 for debugging procedure in HANA SP6.

Before SPS 07, anyone with SYS.DEBUG role was authorized to debug everything, this authorization is no longer required in SPS 07.

Now this restricts the debugging of procedures owned by other users.

With roles:

Grant debug on <proc> to <user>

Grant debug on schema <schema> to <user>

By giving these roles, users can be assigned for debugging a particular procedure or at schema level.

Let’s start debugging now…

First create a wrapper procedure and set the break point (open is _SYS_BIC schema):

Open debug prospective and configure a new debugger.

Now select Catalog schema and select the procedure to debug from the schema, click ‘Browse’ button on the right.

OUT_MARA has one row selected.