* 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