From: <sinisa
Date: March 19 1999 12:59am
Subject: Privileges, users and databases
List-Archive: http://lists.mysql.com/mysql/542
Message-Id: <14065.41348.39915.126331@monster.local.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Levy Carneiro Jr. writes:
 > 
 > 	Hi,
 > 
 > 	I've created a user in mysql server and a database for him. The
 > privileges in mysql database at user table are ok for this user. What I
 > have to do to limit this user to see only this database?
 > 
 > 
 > 
 > 	Thanks,
 > 
 > _______________________________________
 > Levy Carneiro Jr.	<levy@stripped>
 >     Sao Paulo       -       Brasil
 >      *** Jesus loves you !!! ***
 > 

Hi!

Simply, set all of enum fields in user table (select_priv,.....) to
'N' and in db table set corresponding enum fields to 'Y'.

Even better if you are using 3.22.11 or later, use GRANT syntax to do
it. First GRANT  (e.g.) file on *.* to user identified by password,
and then grant select, insert, .. .on db.* to user. 

Sinisa

+---------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___        ==  mysql@stripped        |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|        Sinisa Milivojevic      |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|        mailto:sinisa@stripped |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|        Belgrade                |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____   Serbia                  |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                           |
|             /*/             \*\                   Developers Team   |
+---------------------------------------------------------------------+