You could use views but they will not be available until version 5 or 5.1 In the doc you can find :
Views are useful for allowing users to access a set of relations (tables) as if it were a single table, and limiting their access to just that. Views can also be used to restrict access to rows (a subset of a particular table). One does not require views to restrict access to columns, as MySQL Server has a sophisticated privilege system. See section 5.4 The MySQL Access Privilege System (http://www.mysql.com/doc/en/Privilege_system.html). Maybe this could help you Francisco -----Original Message----- From: Manuele [mailto:[EMAIL PROTECTED] Sent: Thursday, February 26, 2004 5:44 PM To: [EMAIL PROTECTED] Subject: Permissions Hello, I'd like to apologize, I know what I am asking is probably impossibile, but I would like to know if someone has a way to set up permissions on a row basis, for example if a certain condition matches (for example, grant select on row if columnA is NULL). Anyone has any idea on how to do so? I wouldn't like to devolve this to the application, as users will have a mysql username/password and they MIGHT directly connect to the db. Thanks in advance. -- Manuele ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
