Access denied
Posted by:
Asad Raza
Date: October 24, 2010 02:55AM
Dear All,
I have created a read only user using following command
grant select on storedb.view_transactions to 'testing'@'127.0.0.1' identified by 'testing';
When I try to generate CSV with through 'testing' user it gives me following error
"ERROR 1045 (28000): Access denied for user 'testing'@'127.0.0.1' (using password: YES)"
However I can do select * from view_transactions without any issue. I believe some privilege needs to be granted to 'testing' user in order to be able to generate CVS. Please help me in this regard.
Any help will greatly be appreciated.
Subject
Views
Written By
Posted
Access denied
4607
October 24, 2010 02:55AM
1592
October 24, 2010 11:14PM
1628
October 25, 2010 04:46AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.