You can create separate databases (database directories) and then grant
privileges to users on table only within a specific database.
So if you have a separate database (create database <name> is the syntax to
create a new database), you can do that.
Bhavin.
----- Original Message -----
From: "Alice Tan" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, November 27, 2002 10:24 PM
Subject: MySQL secure access
> Hi, all,
>
> I am now using MySQL with MySQL Front, where i knew that it can access
> ALL
> the databases that store remotely.
>
> My company is doing hosting services. And we are using MySQL as
> our database system. Currently, we have our own databases + customer's
> databases
> store in our hosting server. But our customer requested to have their
> own access on their databases, which i don't want them to see those
> databases
> that not belongs to them. Can i do that ?
>
> Thanx in advance for anyhelp.
>
> regards,
> alice
>
>
>
>
/---------------------------------------------------------------------------
\
>
> Confidential and/ or privileged information may be contained in this
> e-mail and any attachments transmitted with it ('Message'). If you are
> not the addressee indicated in this Message (or responsible for
> delivery of this Message to such person),you are hereby notified that
> any dissemination, distribution, printing or copying of this Message or
> any part thereof is prohibited. Please delete this Message if received
> in error and advise the sender by return e-mail. Opinions, conclusions
> and other information in this Message that do not relate to the
> official business of this company shall be understood as neither given
> nor endorsed by this company.
>
> This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd)
> *Scanner Engine powered by Norman Virus Control
>
>
\--------------------------------------------------------------------------/
>
>
> ---------------------------------------------------------------------
> 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
