Help required with Hana user specific trace & SQL trace

[former_member409309]

Dear Guru's,

Kindly help with below 2 queries related to SAP HANA Studio

1) I have enabled SQL traced, it recorded tracing only for system privilege & object privilege but not Analytical related privilege, please confirm if SQL trace is restricted to only for system privilege & object privilege authorization issues. I tried to execute one of the calculation views and i could not see trace file generated

2) I have enabled user defined trace and i can see that trace file is generated but it is showing that only trace is swithced on and off by me, nothing related to authorization is recorded. Below i am pasting the content of the user defined trace file. I logged with HANAUSER ID and enabled trace for the same id.

[61253]{303056}[97/162128592] 2020-04-12 12:49:33.850003 i TraceContext TraceContext.cpp(01114) : UserName=HANAUSER, ApplicationUserName=hana37, ApplicationName=HDBStudio, ApplicationSource=csns.admin.AdminConnection.openConnection(AdminConnection.java:99);csns.admin.trace.wizard.TraceUserPage$6$1.call(TraceUserPage.java:329);csns.admin.trace.wizard.TraceUserPage$6$1.call(TraceUserPage.java:1);java.util.concurrent.FutureTask.run(FutureTask.java:266);java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149);java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624);java.lang.Thread.run(Thread.java:836);, StatementHash=8b844314682d8a4963741c67cf8d6dcf, StatementExecutionID=844437815320543

[61253]{303056}[97/162128592] 2020-04-12 12:49:33.849990 i SQLSessionCmd Statement.cc(07360) : INI configuration is changed by 303056, client ip=192.168.1.147, client port=16816, query=alter system alter configuration ('global.ini','SYSTEM') SET ('traceprofile_trace11', 'application_user') = 'HANAUSER' with reconfigure

[60562]{303056}[-1/-1] 2020-04-12 12:49:34.504659 i TraceContext TraceContext.cpp(01114) : UserName=HANAUSER, ApplicationUserName=hana37, ApplicationName=HDBStudio, ApplicationSource=csns.admin.AdminConnection.openConnection(AdminConnection.java:99);csns.admin.trace.wizard.TraceUserPage$6$1.call(TraceUserPage.java:329);csns.admin.trace.wizard.TraceUserPage$6$1.call(TraceUserPage.java:1);java.util.concurrent.FutureTask.run(FutureTask.java:266);java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149);java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624);java.lang.Thread.run(Thread.java:836);, StatementHash=8b844314682d8a4963741c67cf8d6dcf, StatementExecutionID=844437815320543

[60562]{303056}[-1/-1] 2020-04-12 12:49:34.504655 i EventHandler EventManagerImpl.cpp(00938) : AutoEventHandlerCallback::initial(period= 60)[60562]{303056}[-1/-1] 2020-04-12 12:49:34.504680 i EventHandler EventManagerImpl.cpp(00620) : reportEvent: InternalEvent: Found offline changes for: global.ini SYSTEM ;

[60549]{303041}[94/162128710] 2020-04-12 12:50:04.209556 i TraceContext TraceContext.cpp(01114) : UserName=HANAUSER, ApplicationUserName=hana37, ApplicationName=HDBStudio, ApplicationSource=csns.admin.commands.AdministrationHandler$1$1.call(AdministrationHandler.java:338);csns.admin.commands.AdministrationHandler$1$1.call(AdministrationHandler.java:1);java.util.concurrent.FutureTask.run(FutureTask.java:266);java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149);java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624);java.lang.Thread.run(Thread.java:836);, StatementHash=35f2d381b65d67685648b85509588031, StatementExecutionID=844437815321150

[60549]{303041}[94/162128710] 2020-04-12 12:50:04.209548 i SQLSessionCmd Statement.cc(07360) : INI configuration is changed by 303041, client ip=192.168.1.147, client port=16816, query=alter system alter configuration ('global.ini', 'SYSTEM') unset ('traceprofile_trace11', 'authorization') with reconfigure

[60549]{303041}[94/162128713] 2020-04-12 12:50:04.881563 i TraceContext TraceContext.cpp(01114) : UserName=HANAUSER, ApplicationUserName=hana37, ApplicationName=HDBStudio, ApplicationSource=csns.admin.commands.AdministrationHandler$1$1.call(AdministrationHandler.java:338);csns.admin.commands.AdministrationHandler$1$1.call(AdministrationHandler.java:1);java.util.concurrent.FutureTask.run(FutureTask.java:266);java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149);java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624);java.lang.Thread.run(Thread.java:836);, StatementHash=da0b6725240d1455536a6b956af87d92, StatementExecutionID=844437815321154

[60549]{303041}[94/162128713] 2020-04-12 12:50:04.881551 i SQLSessionCmd Statement.cc(07360) : INI configuration is changed by 303041, client ip=192.168.1.147, client port=16816, query=alter system alter configuration ('global.ini', 'SYSTEM') unset ('traceprofile_trace11', 'sql_user') with reconfigure

Thanks in advance for helping with this

[Kai_Mueller]

Hi,

I'm not sure about the part in regards to the SQL trace. What do you mean exactly? Basically, after applying the filters, the SQL trace will capture everything which goes thru the SQL interface.

In regards to the trace is my guess, that your application user name is not like you think. As you can see you filter on the application user HANAUSER. But in the lines around you can see that you r application user name is in reality hana37. I recommend to set a filter on the user name and not the application user name.

Best regards, Kai