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
[email protected]
PAULLOW1
PAULLOW_10123456782012345678301234567840123456785012345678601234567870123456788012345678901234567100123456711012345671201234127
--- SQL operation complete.
>>unregister user
>>paullow_10123456782012345678301234567840123456785012345678601234567870123456788012345678901234567100123456711012345671201234127;
--- SQL operation complete.
>>get users;
Users
=====
"TEST\#+[ ]<;>"
DB__ROOT
[email protected]
PAULLOW1
PAULLOW_10123456782012345678301234567840123456785012345678601234567870123456788012345678901234567100123456711012345671201234127
--- SQL operation complete.
>>register user paullow4 as asdfgh;
--- SQL operation complete.
>>get users;
Users
=====
"TEST\#+[ ]<;>"
ASDFGH
DB__ROOT
[email protected]
PAULLOW1
PAULLOW_10123456782012345678301234567840123456785012345678601234567870123456788012345678901234567100123456711012345671201234127
--- SQL operation complete.
>>unregister user asdfgh;
--- SQL operation complete.
>>get users;
Users
=====
"TEST\#+[ ]<;>"
DB__ROOT
[email protected]
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)
