[Gllug] MySQL - hiding databases

[Jackson, Harry]

Hi Paul


Have a look at the following two Variables in MySql

safe_show_databases
and
skip_show_databases


In particular the last one which will let you hide it from the users without
the process privilege which I think is what you are looking for.


Harry

> -----Original Message-----
> From: Paul Brazier [mailto:pbrazier at cosmos-uk.co.uk]
> Sent: 16 October 2001 08:54
> To: Gllug (E-mail)
> Subject: [Gllug] MySQL - hiding databases
> 
> 
> Does anyone know if it's possible to "hide" databases from users in
> MySQL?
> 
> i.e. so the output of "SHOW DATABASES" only shows the 
> databases that the
> user has access rights to.
> At the moment it's listing all databases.
> 
> --
> Paul Brazier
> Cosmos UK 
> 
> 
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the originator.
> 
> This footnote also confirms that this email message has been checked
> for the presence of computer viruses.
> 
> **********************************************************************
> 
> 
> -- 
> Gllug mailing list  -  Gllug at linux.co.uk
> http://list.ftech.net/mailman/listinfo/gllug
> 


**********************************************************************
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. 020 7390 3900

This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or 
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message.  Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.


**********************************************************************


-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug