You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:15:39 UTC
[jira] [Created] (TRAFODION-328) LP Bug: 1324649 - sql-security
UNREGISTER USER did not remove user
Alice Chen created TRAFODION-328:
------------------------------------
Summary: LP Bug: 1324649 - sql-security UNREGISTER USER did not remove user
Key: TRAFODION-328
URL: https://issues.apache.org/jira/browse/TRAFODION-328
Project: Apache Trafodion
Issue Type: Bug
Components: sql-security
Reporter: Paul Low
Assignee: Roberta Marton
Priority: Critical
User "paullow_10123456782012345678301234567840123456785012345678601234567870123456788012345678901234567100123456711012345671201234127" was not removed when UNREGISTER USER returned with a successful message. The log below shows that a different user "asdfgh" was unregistered successfully. In other tests, user "TEST\#+[ ]<;>" also failed during UNREGISTER USER.
This is the second time I have seen this happen.
>>register user paullow2 as paullow_10123456782012345678301234567840123456785012345678601234567870123456788012345678901234567100123456711012345671201234127;
--- SQL operation complete.
>>get users;
Users
=====
"TEST\#+[ ]<;>"
DB__ROOT
PAUL.LOW@HP.COM
PAULLOW1
PAULLOW_10123456782012345678301234567840123456785012345678601234567870123456788012345678901234567100123456711012345671201234127
--- SQL operation complete.
>>unregister user paullow_10123456782012345678301234567840123456785012345678601234567870123456788012345678901234567100123456711012345671201234127;
--- SQL operation complete.
>>get users;
Users
=====
"TEST\#+[ ]<;>"
DB__ROOT
PAUL.LOW@HP.COM
PAULLOW1
PAULLOW_10123456782012345678301234567840123456785012345678601234567870123456788012345678901234567100123456711012345671201234127
--- SQL operation complete.
>>register user paullow4 as asdfgh;
--- SQL operation complete.
>>get users;
Users
=====
"TEST\#+[ ]<;>"
ASDFGH
DB__ROOT
PAUL.LOW@HP.COM
PAULLOW1
PAULLOW_10123456782012345678301234567840123456785012345678601234567870123456788012345678901234567100123456711012345671201234127
--- SQL operation complete.
>>unregister user asdfgh;
--- SQL operation complete.
>>get users;
Users
=====
"TEST\#+[ ]<;>"
DB__ROOT
PAUL.LOW@HP.COM
PAULLOW1
PAULLOW_10123456782012345678301234567840123456785012345678601234567870123456788012345678901234567100123456711012345671201234127
--- SQL operation complete.
>>
Log in with the username through sqlci shows that the user record is still present
-bash-4.1$
-bash-4.1$ sqlci -u sdfg
Trafodion Conversational Interface 0.7.0
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
*** ERROR[8732] User SDFG is not a registered database user.
>>exit;
End of MXCI Session
-bash-4.1$ sqlci -u paullow_10123456782012345678301234567840123456785012345678601234567870123456788012345678901234567100123456711012345671201234127
Trafodion Conversational Interface 0.7.0
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
Database user: PAULLOW_10123456782012345678301234567840123456785012345678601234567870123456788012345678901234567100123456711012345671201234127
>>exit;
End of MXCI Session
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)