This shows you the differences between two versions of the page.
dev:sql:functions:user [2009/12/05 00:52] tdo created |
dev:sql:functions:user [2010/07/28 22:42] els |
||
---|---|---|---|
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_USER, SESSION_USER functions return the current user of Omnidex as entered when first connected to the current open environment. If no user was entered, the user of "DEFAULT" is returned. The return data type is a C 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 layer, and so these functions always return a value of "DEFAULT". |
+ | |||
+ | This function returns a C 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}} | ||
+ |