You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Roberta Marton (JIRA)" <ji...@apache.org> on 2016/03/14 20:32:33 UTC
[jira] [Work started] (TRAFODION-1843) Allow USER option(s) to be
defined as defaults in a table column definition
[ https://issues.apache.org/jira/browse/TRAFODION-1843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on TRAFODION-1843 started by Roberta Marton.
-------------------------------------------------
> Allow USER option(s) to be defined as defaults in a table column definition
> ---------------------------------------------------------------------------
>
> Key: TRAFODION-1843
> URL: https://issues.apache.org/jira/browse/TRAFODION-1843
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: sql-cmu
> Reporter: Roberta Marton
> Assignee: Roberta Marton
>
> SQL ANSI allows you to specify: USER, CURRENT_USER, and SESSION_USER as default options associated with the <default-clause> when creating a column definition for a table. Trafodion should support similar functionality.
> USER and SYSTEM_USER are semantically the same and irepresents the value of the current authorization identifier.
> SESSION_USER is the values of the SQL session authorization identifier
> Support for USER, CURRENT_USER, and SESSION_USER exist in the code and can be used, for example, in insert statements.
> All user values should be returned as a varchar 128 to match the current implementation.
> ANSI also support a SYSTEM_USER option. The SYSTEM_USER is an implementation defined value that represents the operating system user related to the process running the request. At this time, there are no plans to support the SYSTEM_USER.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)