* Andi S. Giri
> Can mysql have different tables for different users ?

Yes.

> Say user 'TEST1'
> creates a table called 'XYZ' and also user 'TEST2' creates the same table
> name 'XYZ'
>
> Is it allowed ?

Yes, if you give each user his own database.

> If it is, can this two tables can be accesed by a
> third user
> say 'Superuser' provided the priveleges are given by 'TEST1' and 'TEST2' ?

Yes, except the privileges can not be given by each user, it must be given
by the mysql root user.

--
Roger


---------------------------------------------------------------------
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

Reply via email to