Hi What about encrypting the data using a password that is specific to the user. That way only those that know the password for that row can access it.
Locking is really to stop two users editing the same record at the same time, rather than controlling access. HTH Peter > -----Original Message----- > From: Jonas Ladenfors [mailto:[EMAIL PROTECTED] > Sent: 18 November 2004 09:46 > To: Mysql (E-mail) > Subject: Row level security requirements, can I still use MySQL? > > > Hello, I am in the position where I need row level user access, this is > crucial in my current project. I know this has been discussed > before and the > answer has been "use views when they become availble". But views > would still > allow the "root" user access to the complete table, wouldnt it? I > would like > to lock rows to certain user and not let anyone else see them, > not even the > root user. > > I have been thinking about using heap tables or trying to supply each > user/group with their own dynamically created tables. But I always come to > the conclusion that I am hacking away at something I do not fully > understand > and that I cannot guaranty that the end result will have the security I > claim. > > Is this possible in MySQL? > Does anyone know if it cab be performed with other RDBMS? > > Regards > /Jonas > > > > > > -- > 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]
