------=_NextPart_000_0077_01C6FCDD.DDC7AB20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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
------=_NextPart_000_0077_01C6FCDD.DDC7AB20--
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."=20
-----Original Message-----
From: Melissa Dougherty [mailto:melissa@cse-corp.com]
Sent: Tuesday, October 31, 2006 11:15 AM
To: win32@lists.mysql.com
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=20
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org
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"
To: "Melissa Dougherty"
Cc:
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:melissa@cse-corp.com]
Sent: Tuesday, October 31, 2006 11:15 AM
To: win32@lists.mysql.com
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/win32?unsub=gcdmw-win32@m.gmane.org