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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.1
• Assignee: Tom Beerbower
• Reporter: Tom Beerbower
• Created: 07/Apr/14 21:47
• Updated: 07/Apr/14 23:16
• Resolved: 07/Apr/14 23:16

Description

The create table statements for views should not include 'ambari'...

CREATE TABLE ambari.viewmain (view_name VARCHAR(255) NOT NULL, label VARCHAR(255), version VARCHAR(255), archive VARCHAR(255), PRIMARY KEY(view_name));

Should be ...

CREATE TABLE viewmain (view_name VARCHAR(255) NOT NULL, label VARCHAR(255), version VARCHAR(255), archive VARCHAR(255), PRIMARY KEY(view_name));

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

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

Issue Links

• links to: Code review and patch