You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "liu ming (JIRA)" <ji...@apache.org> on 2016/06/14 22:47:30 UTC

[jira] [Assigned] (TRAFODION-1744) Session user information is incorrect in stored procedures

     [ 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)