Page 1 of 1

Simple SQL query interface

Posted: Tue Dec 04, 2007 5:34 pm
by Shendemiar
Id like to give some people ability to view (some of) the tables and do simple SELECT queries of them. Ii there any nice piece of code for that?

Posted: Tue Dec 04, 2007 5:39 pm
by RobertGonzalez
This sounds like a database privileges type question.

Posted: Tue Dec 04, 2007 5:40 pm
by feyd
What level of view are we talking about here?

You could give them a database user with only the rights to select from those tables (and columns) you wish them to be able to access.

Posted: Tue Dec 04, 2007 10:20 pm
by Shendemiar
Sorry... i meant some kind of pre-made interface to do some database viewing like phpmyadmin, but way simpler, and only selects

Posted: Wed Dec 05, 2007 1:44 am
by s.dot
PHPMyAdmin would work (minus the simpler part). I'm pretty sure if they log in as a user that only has select priveledges, they wouldn't be able to do anything else.

Posted: Wed Dec 05, 2007 4:27 pm
by califdon
Shendemiar wrote:Sorry... i meant some kind of pre-made interface to do some database viewing like phpmyadmin, but way simpler, and only selects
I don't know if this will do what you want, but I wrote a rather simple db read-only interface a few months ago you're welcome to use it if it meets your needs: http://ravey.net/demo/

Posted: Sat Dec 08, 2007 5:47 pm
by Shendemiar
califdon wrote:
Shendemiar wrote:Sorry... i meant some kind of pre-made interface to do some database viewing like phpmyadmin, but way simpler, and only selects
I don't know if this will do what you want, but I wrote a rather simple db read-only interface a few months ago you're welcome to use it if it meets your needs: http://ravey.net/demo/
That sounds very nice for my purposes. Thank you.