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:35 UTC
[jira] [Created] (TRAFODION-310) LP Bug: 1323884 - sql-security
REGISTER USER and UNREGISTER USER do not support some special characters
Alice Chen created TRAFODION-310:
------------------------------------
Summary: LP Bug: 1323884 - sql-security REGISTER USER and UNREGISTER USER do not support some special characters
Key: TRAFODION-310
URL: https://issues.apache.org/jira/browse/TRAFODION-310
Project: Apache Trafodion
Issue Type: Bug
Components: sql-security
Reporter: Paul Low
REGISTER USER and UNREGISTER USER commands failed with internal invalid character error.
-bash-4.1$ trafci.sh -h localhost:28200 -u trafodion -p traf
Welcome to Trafodion Command Interface
Copyright(C) 2013-2014 Hewlett-Packard Development Company, L.P.
Host Name/IP Address: localhost:28200
User Name: trafodion
Connected to Trafodion
SQL>register user """TEST\#+[ ]<;>""";
--- SQL operation complete.
SQL>get users;
Users
=====
"TEST\#+[ ]<;>"
DB__ROOT
PAUL.LOW@HP.COM
PAULLOW1
--- SQL operation complete.
SQL>unregister user asdf;
*** ERROR[1333] User ASDF does not exist. [2014-05-27 20:22:46]
SQL>unregister user """TEST\#+[ ]<;>""";
*** ERROR[2109] Invalid Character error converting SQL statement from character set UTF8 to character set UCS2 (character position 73, byte offset 73). [2014-05-27
20:23:36]
SQL>unregister user paullow1;
--- SQL operation complete.
SQL> Register user paullow1 as "last-first\'qa1003";
*** ERROR[15005] Unmatched quote in input (unterminated string):
select count(*) from TRAFODION."_MD_".AUTHS where auth_db_name = 'LAST-FIRST\'QA1003'; [2014-05-27 20:25:22]
SQL>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)