i did create those databases in different databases directories.
i saw there r columns_priv, db, host, tables_priv and user tables in the
mySQL database directory. Is all these tables control the user data access ?
and how ?
> grant privileges to users on table only within a specific database.
can u specify more detail on that ??
----- Original Message -----
From: "Bhavin Vyas" <[EMAIL PROTECTED]>
To: "Alice Tan" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Thursday, November 28, 2002 12:07 PM
Subject: Re: MySQL secure access
> 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
>
>
>
>
/---------------------------------------------------------------------------\
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
