[
https://issues.apache.org/jira/browse/TRAFODION-1744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liu ming reassigned TRAFODION-1744:
-----------------------------------
Assignee: liu ming
> Session user information is incorrect in stored procedures
> ----------------------------------------------------------
>
> Key: TRAFODION-1744
> URL: https://issues.apache.org/jira/browse/TRAFODION-1744
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-general
> Reporter: Roberta Marton
> Assignee: liu ming
>
> If I run a stored procedure in a sqlci session and connect as a user other
> than DB__ROOT, I expected that user identification to be sent to the stored
> procedure. However, the user id is always DB__ROOT.
> As db__root.
> create a procedure. Include the SQL command: values(user);
> grant execute on procedure to sql_user1
> As sql_user
> sqlci -u sql_user1;
> >> values (user);
> (EXPR)
> -----------------------
> SQL_USER1
> call the store procedure and see that the embedded values command returns
> DB__ROOT.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
