[jira] [Created] (AMBARI-5385) Ambari Views : MySQL create script is wrong for View tables

["Tom Beerbower (JIRA)" <ji...@apache.org>]

Tom Beerbower created AMBARI-5385:
-------------------------------------

             Summary: Ambari Views : MySQL create script is wrong for View tables
                 Key: AMBARI-5385
                 URL: https://issues.apache.org/jira/browse/AMBARI-5385
             Project: Ambari
          Issue Type: Bug
            Reporter: Tom Beerbower
            Assignee: Tom Beerbower
             Fix For: 1.5.1


The create table statements for views should not include 'ambari'...
{code}
CREATE TABLE ambari.viewmain (view_name VARCHAR(255) NOT NULL, label VARCHAR(255), version VARCHAR(255), archive VARCHAR(255), PRIMARY KEY(view_name));
{code}
Should be ...
{code}
CREATE TABLE viewmain (view_name VARCHAR(255) NOT NULL, label VARCHAR(255), version VARCHAR(255), archive VARCHAR(255), PRIMARY KEY(view_name));
{code}

Also, remove the GRANT ALL statements for the view tables ... 

{code}
GRANT ALL PRIVILEGES ON TABLE ambari.view TO :username;
{code} 




--
This message was sent by Atlassian JIRA
(v6.2#6252)