How can one select user() and other session information

[Tom Johnston 3]

I"m looking for something like " select user from dual" where user is current_user_name... also other session specific variables..how is this queryable

[Philipp Reiner 3]

In the information designer you can use %CURRENT_USER% to filter to data where the value in a user column equals the logged in user.

[Deepak Kuletha]

Easier way I would suggest is that you can go to manager tab and look for Requests under   which it would show you the user that has logged in alongwith the request it is running .

 

Transaction tab also shows tha users currently logged into the server .

[Tom Johnston 3]

There is confusion here. I mean when connected to a published database one should be able to get session info such as user(), now() and possibly others.  This is an ansi standard though the psuedo column names may differ.

[Deepak Kuletha]

Please use this query for current user

 

Select * from all_users

 

You will see the current user which is logged into studio

[Motsu Aboshi]

There are functions in /lib that can get e.g the current username and domain - you'd probably have to make them custom functions in order to use them the way you're looking to do.

 

 

 

TDV supports NOW() and other similar time functions out of the box, check the Reference Guide for the full SQL support information.

[Allen Yu 3]

%CURRENT_USER%  is for Spotfire Current Log in user, for TDV, you need to define a procedurePROCEDURE sp_current_user(OUT CURRENT_LOGIN_USER VARCHAR(30))

BEGIN

   CALL /lib/util/getProperty('CURRENT_USER_NAME', CURRENT_LOGIN_USER);ENDcreate a view on top of it, publish to each VDB for easy access.