MySQL Forums
Forum List  »  Newbie

Re: users viewing only there data
Posted by: Vlatko Šurlan
Date: March 15, 2006 02:50AM

That would work with MySQL access system. You assign each user a login and a pass, create a single table and set MySQL user privileges so they can access only that table. Note that it is not a very good idea (read its bad bad bad) to have many user restrictions set via MySQL access system since MySQL server then must check these on every query and that slows everything down. Setting this up programmatically is the way to go.

http://www.docplanet.org/mysql/ - My collection of MySQL tips and tricks

Options: ReplyQuote


Subject
Written By
Posted
Re: users viewing only there data
March 15, 2006 02:50AM


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.