I have seen this type of security implemented through multiple VIEWs but not directly by the storage engine. You will need to create a view for your user that exposes only out those rows designated for that user. The drawback to this is that you will need to issue one view for each user or group of users and assign rights appropriately. Another drawback is that your version of MySQL may not support views.
Please read http://dev.mysql.com/doc/mysql/en/create-view.html for the details of creating views and http://dev.mysql.com/doc/mysql/en/grant.html for instructions on how to set permissions. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Thomas Matthews <[EMAIL PROTECTED]> wrote on 02/01/2005 02:47:00 AM: > Hello, > > I am wondering if it is possible to limit privileges for a user account > based on information stored within specific columns. For example, I > plan to include a `username` column on a table with the hope of having > each user log into the database using their own credentials and only be > able to INSERT, UPDATE, SELECT, DELETE rows where their username is what > the `username` column is populated with. > > Keep in mind that the users will have access to issue any query they > wish against the database so I would like to restrict this at the server > level. > > Thank you in advance. > > -- > Thomas Matthews > [EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
