You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Roberta Marton (JIRA)" <ji...@apache.org> on 2018/04/17 15:39:00 UTC

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

     [ https://issues.apache.org/jira/browse/TRAFODION-2000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Roberta Marton closed TRAFODION-2000.
-------------------------------------
    Resolution: Fixed

Not relevant

> 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
>            Assignee: Roberta Marton
>            Priority: Major
>
> 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
(v7.6.3#76005)