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
* 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
Hello
Can mysql have different tables for different users ? Say user 'TEST1'
creates a table called 'XYZ' and also user 'TEST2' creates the same table
name 'XYZ'
Is it allowed ? If it is, can this two tables can be accesed by a third user
say 'Superuser' provided the priveleges are given by 'TEST
