On Thu, 18 Nov 2004 10:45:37 +0100, Jonas Ladenfors wrote: > 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.
The only way to do that is client side encryption. Otherwise a sufficiently privileged user can still see the data. (Even if it is just by sniffing the network traffic or attaching a custom debugger to the running process.) Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]