re: Users and their priveleges in a mySQL Database

2002-12-03 Thread Victoria Reznichenko
Andi, Tuesday, December 03, 2002, 8:52:33 AM, you wrote: ASG> Can mysql have different tables for different users ? Say user 'TEST1' ASG> creates a table called 'XYZ' and also user 'TEST2' creates the same table ASG> name 'XYZ' ASG> Is it allowed ? Yes. Table names must be unique within a databa

Re: Users and their priveleges in a mySQL Database

2002-12-03 Thread Roger Baklund
* 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