SELECT command denied to user 'user'@'localhost' for table 'TABLE' in OBIEE 11g after connecting to
Hi All,
I am getting the error "SELECT command denied to user 'user'@'localhost' for table 'TABLE'" when trying to execute a Query from the data model creation page of the BI Analytics of OBIEE 11g,
The data is coming from the MySQL database of ZABBIX.
The connection was successful and I am able to see the tables and their columns to which the grant has been given, but when I do a 'select' from those tables I am seeing this Error.
Can anyone help me with this issue,
Thanks,
Prashant.
I am getting the error "SELECT command denied to user 'user'@'localhost' for table 'TABLE'" when trying to execute a Query from the data model creation page of the BI Analytics of OBIEE 11g,
The data is coming from the MySQL database of ZABBIX.
The connection was successful and I am able to see the tables and their columns to which the grant has been given, but when I do a 'select' from those tables I am seeing this Error.
Can anyone help me with this issue,
Thanks,
Prashant.
0