I have a database of content that I would like to allow buyers access to. I want them to be able to access the database, but not be able to alter it or download it. Their only options would be able to view it or display it.
I am seeking options and or avenues on how I could approach this. Any suggestions are appreciated.
through a web site? or direct access through a database gui?
I am not sure what approach I would want to take. I was thinking maybe a direct access for those interested in using the information for their own apps, but for someone that might just want to view the information I could set up a website so they could view it. Im just in the beginning thoughts right now. I was also looking at the possibility of using zoho.com.
granting direct access means that you hand out userids and passwords, and then use the GRANT command to tailor access to those users (can be at the table level)
web access would use a general userid, which only the web app knows the password of, and which has read access only to all tables
Thanks for the info. What would be your approach?
This topic is now archived. It is frozen and cannot be changed in any way.