This shows you the differences between two versions of the page.
dev:sql:functions:current_user [2009/12/05 00:17] tdo created |
dev:sql:functions:current_user [2010/07/28 22:41] 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: CURRENT_USER ====== | ||
{{page>:sql_bar&nofooter&noeditbtn}} | {{page>:sql_bar&nofooter&noeditbtn}} | ||
+ | |||
+ | ====== Omnidex SQL Function: CURRENT_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. | ||
===== Syntax ===== | ===== Syntax ===== | ||
- | CURRENT_USER | + | CURRENT_USER |
- | ===== Example ===== | + | |
- | ==== Example 1 ==== | + | ===== Examples ===== |
- | <code SQL> | + | ==== Example 1: Column ==== |
- | select company, current_user from customers where company='dynamic' | + | <code> |
+ | > select current_user from $omnidex; | ||
+ | |||
+ | CURRENT | ||
+ | ------- | ||
+ | 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}} | ||
+ |