[ https://issues.apache.org/jira/browse/TRAFODION-1744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
liu ming updated TRAFODION-1744: -------------------------------- Assignee: mashengchen (was: 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: mashengchen > > 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)