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)
