Restricting query access to database information
I am developing a Java Server Faces (JSF) application which uses MySQL v6.0 (Community). I only want select queries to be available from the application itself. I do not want the DB administrator to be able to view table data or to be able to make any queries manually. Is there any way to achieve this? I was thinking of restricting privileges but then this might affect the actual application and not allow data to be displayed.
Just to be clear, I would like the application to render data normally but I do not want the administrator to be able to make queries manually from the command prompt or from any other interface outside the application security realm. Please let me know if this makes sense or if I need to provide any further information. Thanks in advance.
Subject
Views
Written By
Posted
Restricting query access to database information
4154
August 12, 2014 07: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.