Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
dev:sql:functions:session_user [2009/12/05 00:43]
tdo created
dev:sql:functions:session_user [2016/06/28 22:38] (current)
Line 1: Line 1:
 {{page>:​top_add&​nofooter&​noeditbtn}} {{page>:​top_add&​nofooter&​noeditbtn}}
-<​html><​div align="​center"><​span style="​color:​red">​DRAFT</​span></​div></​html>​ 
-====== Omnidex SQL Function: SESSION_USER ====== 
 {{page>:​sql_bar&​nofooter&​noeditbtn}} {{page>:​sql_bar&​nofooter&​noeditbtn}}
 +
 +====== Omnidex SQL Function: SESSION_USER ======
 ===== Description ===== ===== Description =====
-The USER, CURRENT_USERSESSION_USER functions return the current user of Omnidex ​as entered when first connected to the current open environmentIf no user was enteredthe user of "​DEFAULT" ​is returnedThe return data type is STRING ​maximum length 32.+The USER, CURRENT_USER ​and SESSION_USER functions return the current user of Omnidex. ​ ​Omnidex does not provide a user security layerand so these functions always return a value of "​DEFAULT"​. ​  
 + 
 +This function returns ​a STRING ​datatype.
  
-These functions are identical. 
 ===== Syntax ===== ===== Syntax =====
-  ​SESSION_USER +SESSION_USER 
-===== Example ​===== + 
-==== Example 1 ==== +===== Examples ​===== 
-<​code ​SQL+==== Example 1: Column ​==== 
-select ​company, ​session_user from customers where company='​dynamic'​+<​code>​ 
 +select session_user from $omnidex; 
 + 
 +SESSION 
 +------- 
 +DEFAULT
  
-Dynamic Information Systems Corporation,​ DEFAULT 
 </​code>​ </​code>​
 +
 +====== Additional Resources ======
 +
 +See also:
 +{{page>​dev:​sql:​functions:​see_also_variables&​nofooter&​noeditbtn&​noheader}}
 +
 {{page>:​bottom_add&​nofooter&​noeditbtn}} {{page>:​bottom_add&​nofooter&​noeditbtn}}
 +
 
Back to top
dev/sql/functions/session_user.1259973807.txt.gz · Last modified: 2016/06/28 22:38 (external edit)