TT-03159
SELECT not allowed on invalid materialized view view_name
Cause
When a materialized view is invalid, the owner of the view does not have SELECT privileges on every detail table referenced by that view.
Action
To fix an invalid materialized view, re-grant SELECT privileges on every detail table to the view owner (or grant higher-level privileges such as SELECT ANY TABLE or ADMIN). Once the privileges are granted, drop the materialized view, and then re-create it.
Additional Information
TimesTen cannot execute the SQL statement.
TT-03159
SELECT not allowed on invalid materialized view view_name
Cause
When a materialized view is invalid, the owner of the view does not have SELECT privileges on every detail table referenced by that view.
Action
To fix an invalid materialized view, re-grant SELECT privileges on every detail table to the view owner (or grant higher-level privileges such as SELECT ANY TABLE or ADMIN). Once the privileges are granted, drop the materialized view, and then re-create it.
Additional Information
TimesTen cannot execute the SQL statement.
TT-03159
SELECT not allowed on invalid materialized view view_name
Cause
When a materialized view is invalid, the owner of the view does not have SELECT privileges on every detail table referenced by that view.
Action
To fix an invalid materialized view, re-grant SELECT privileges on every detail table to the view owner (or grant higher-level privileges such as SELECT ANY TABLE or ADMIN). Once the privileges are granted, drop the materialized view, and then re-create it.
Additional Information
TimesTen cannot execute the SQL statement.
