You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/08/31 07:37:10 UTC
[jira] [Closed] (TRAFODION-1056) LP Bug: 1431531 - Non-DB__ROOT has
no privilege to cancel own query
[ https://issues.apache.org/jira/browse/TRAFODION-1056?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah closed TRAFODION-1056.
-------------------------------------
Resolution: Fixed
Close issues in JIRA to reflect status in LaunchPad
> LP Bug: 1431531 - Non-DB__ROOT has no privilege to cancel own query
> -------------------------------------------------------------------
>
> Key: TRAFODION-1056
> URL: https://issues.apache.org/jira/browse/TRAFODION-1056
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Apache Trafodion
> Assignee: Apache Trafodion
>
> By design we want any user to have the privilege to cancel her own query. But this bug causes the error 8029 to be returned if the user is not DB__ROOT, not the user who issued the subject query and has not be granted the QUERY_CANCEL component privilege in SQL_OPERATIONS:
> Trafodion Conversational Interface 1.1.0
> (c) Copyright 2014 Hewlett-Packard Development Company, LP.
> Database user: SQL_USER7
> >>prepare s1 from values(user());
> --- SQL command prepared.
> >>display qid for s1;
> QID is MXID11000026882212292948914220434000000000206U3333400_43_S1
> QID details:
> ============
> Segment Num: 0
> Segment Name:
> Cpu: 0
> Pin: 26882
> ExeStartTime: 212292948914220434= 2015/03/12 19:35:14.220434 LCT
> SessionNum: 2
> UserName: U33334
> SessionName: NULL
> QueryNum: 43
> StmtName: S1
> SessionId: MXID11000026882212292948914220434000000000206U3333400
> >>execute s1;
> (EXPR)
> ---------------------------------------------------------------------------------------------------------------------------------
> SQL_USER7
> --- 1 row(s) selected.
> >>control query cancel qid
> +>MXID11000026882212292948914220434000000000206U3333400_43_S1;
> *** ERROR[8029] Server declined cancel request. The user is not authorized to make this request.
> *** ERROR[8822] The statement was not prepared.
> >>
> Assigned to LaunchPad User Mike Hanlon
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)