Dear Lenz,
> `Show_db_priv` enum('N','Y') NOT NULL default 'N'
> i.e. User must be granted explicitly this privilege in order to be
able to use:
> SHOW DATABASES;
> Suggested way for setting this Ptivilege is ofcourse command:
> GRANT SHOW DATABASES;
Sound it bit strange in a "GRANT select, show databases, update" context
as it has two words, in opposite to all other privileges that have only
one word.
> I hope you will agree that this approach provides much better
flexibility and
> is more natural than mysqld starting option.
Totally agree :)
Regards,
--
Stefan Hinz <[EMAIL PROTECTED]>
Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
----- Original Message -----
From: "Alexander Keremidarski" <[EMAIL PROTECTED]>
To: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>
Cc: "Lenz Grimmer" <[EMAIL PROTECTED]>; "MySQL announce list"
<[EMAIL PROTECTED]>; "MySQL mailing list" <[EMAIL PROTECTED]>
Sent: Friday, November 29, 2002 11:15 AM
Subject: Re: MySQL 4.0.5(a) is released
> Dear Stefan,
> Stefan Hinz, iConnect (Berlin) wrote:
> > Dear Lenz,
> >
> >
> >>Removed variable `safe_show_database' as it was not used anymore.
> >
> >
> > What will ISPs say about this one? They use 'safe_show_database' for
their
> > MySQL setups, so their customers on virtual MySQL hosts cannot see
other
> > customers' databases. (It's more likely that you won't attack
something
> > which you cannot see.)
> >
> > Or am I missing out on something?
>
>
> Functionality is still there, but implemented at the place it belongs
to.
>
> Pay attention on Privlieges tables 4.0.5 uses. You will see there is:
>
> `Show_db_priv` enum('N','Y') NOT NULL default 'N'
>
> i.e. User must be granted explicitly this privilege in order to be
able to use:
> SHOW DATABASES;
>
> Suggested way for setting this Ptivilege is ofcourse command:
> GRANT SHOW DATABASES;
>
> I hope you will agree that this approach provides much better
flexibility and is
> more natural than mysqld starting option.
>
> If you still have concerns, please don't hesitate to share them with
us.
>
> --
> For technical support contracts, visit https://order.mysql.com/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski
<[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
> /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
> <___/ www.mysql.com
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
