List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:March 19 1999 12:59am
Subject:Privileges, users and databases
View as plain text  
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   |
+---------------------------------------------------------------------+
Thread
Privileges, users and databasesLevy Carneiro Jr.18 Mar
  • Privileges, users and databasessinisa19 Mar
    • Re: Privileges, users and databasesPaul DuBois19 Mar
      • Re: Privileges, users and databasessinisa20 Mar