One of our client's developer wants to have access to the DB to query the tables and its contents. We do not want to provide an access with which he should be able to change any table contents (inadvertently). We are looking something like PHPMyadmin or SQLWorkbench access, but only in read-only mode.
Adding complexity he works from home and have a broadband with dynamic IP. Hence it seems we cannot grant IP based access as well.
As an alternate idea, we thought of replicating the database on to another server and grant full access to that replicated one so that we can be safe and satisfy the need. But this involves additional cost and the changes will not be replicated immediately.
Any ideas to expose the existing RDS as read-only will be a great advantage and is highly appreciated.