Hi everybody,
my apologies for this somewhat simple question, but still...
What's the best way to find out the user that's currently active? On the SAPDB help pages I found an SQL statement which I adjusted to return the Usename instead of the machine he is using:
 
SELECT username
FROM DOMAIN.CONNECTEDUSERS cu, DOMAIN.CONNECTPARAMETERS cp
WHERE cu.session = cp.session
 
This works fine. However, I couldn't find a way to allow an ordinary user to run it. 
So my question is: Isn't there a simpler way, like some function or variable holding the active user?
If not, how do I empower the average user to run the SQL statement? 
I tried creating a view and granting the neccessary rights to the view, but to no avail, I get the same error.
(Which is Native error -5001, Syntax Error or Access Violation, Missing Privilege)
 
Thanks in advance
Marco