You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Gao, Rui-Xian (JIRA)" <ji...@apache.org> on 2016/05/18 15:44:12 UTC

[jira] [Created] (TRAFODION-2000) trafodion is not picked up as DB__ROOT if security is enabled after install

Gao, Rui-Xian created TRAFODION-2000:
----------------------------------------

             Summary: trafodion is not picked up as DB__ROOT if security is enabled after install
                 Key: TRAFODION-2000
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2000
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-security
    Affects Versions: 2.1-incubating
         Environment: centos6.7 hbase1.0 CDH5.4.8
            Reporter: Gao, Rui-Xian



users for DB__ROOT and DB__ADMIN are same, both are 'trafodion', and DB__ADMIN is picked up for trafodion.  

SQL>showddl user db__root;


REGISTER USER "TRAFODION" AS "DB__ROOT";

--- SQL operation complete.

SQL>showddl user db__admin;


REGISTER USER "TRAFODION" AS "DB__ADMIN";

--- SQL operation complete.

SQL>values(user);

(EXPR)
--------------------------------------------------------------------------------------------------------------------------------
DB__ADMIN                                                                                              

--- 1 row(s) selected.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)