Re: INFORMATION_SCHEMA -- Permissions

I understand..... however, my developer is asking if I can revoke that 
privilege.  He doesn't want them to see any db but there own.


----- Original Message ----- 
From: "Don Lancaster" <[email protected]>
To: "Melissa Dougherty" <[email protected]>
Cc: <[email protected]>
Sent: Tuesday, October 31, 2006 11:27 AM
Subject: RE: INFORMATION_SCHEMA -- Permissions


By default, users can access information about objects that they have 
permissions to use anyway.  From the MySQL 5.0 Manual:  "Each MySQL user has 
the right to access these tables, but can see only the rows in the tables 
that correspond to objects for which the user has the proper access 
privileges. In some cases (for example, the ROUTINE_DEFINITION column in the 
INFORMATION_SCHEMA.ROUTINES table), users who have insufficient privileges 
will see NULL."


-----Original Message-----
From: Melissa Dougherty [mailto:[email protected]]
Sent: Tuesday, October 31, 2006 11:15 AM
To: [email protected]
Subject: INFORMATION_SCHEMA -- Permissions


Does anyone know how to restrict users from seeing the INFORMATION_SCHEMA 
database/data?  I can't find any explicit grants, but we don't want users to 
access this information.

Thanks,


Melissa


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]