Differences

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

Link to this comparison view

Next revision
Previous revision
dev:sql:functions:user [2009/12/05 00:52]
tdo created
dev:sql:functions: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: USER ====== 
 {{page>:​sql_bar&​nofooter&​noeditbtn}} {{page>:​sql_bar&​nofooter&​noeditbtn}}
 +
 +====== Omnidex SQL Function: 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 =====
-  ​USER +USER
-===== Example ===== +
-==== Example 1 ==== +
-select company, user from customers where company='​dynamic'​+
  
-Dynamic Information Systems Corporation, ​DEFAULT +===== Examples ===== 
-...+==== Example 1: Column ==== 
 +<​code>​ 
 +> select user from $omnidex; 
 + 
 +USER 
 +------- 
 +DEFAULT 
 + 
 +</​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/user.1259974336.txt.gz · Last modified: 2016/06/28 22:38 (external edit)