Only being able to see certain rows is not a function of MySQL, it is a function of the application you write for the user to access the database. If a user has permission to read a table, they can read all rows. It is up to your application to make sure they are only seeing rows that apply to them.
j----- k----- On Tuesday 09 March 2004 05:57 pm, Mulugeta Maru wrote: > Thank you for the kind response. May be I did not clearly ask the question. > The user table in mysql database is used to set-up a user and password. > Once I set-up my tables (customer, customer orders, customer order details, > etc) in say abc database what will I have to do to make sure when customer > A logs in to the database can only see his/her account, orders, order > details without getting access to other customer accounts. -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... .... ..- .- -.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
