Hi!

On Nov 18, 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.

In MySQL there's no concept of "root" user.

If you make sure that no user on the system has select privileges on the
underlying tables, than nobody will be able to select from them.
 
Regards,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/  www.mysql.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to