hello eveybody,

I have an Sql server 2000 installed with several databases.
this instance is configured with both sql server identification and
Windows ID

I have created a login called « john »and this login has a default
database « mydb » (sp_addlogin)

On this default database, i have granted the Access to this login
(sp_grantdbaccess)


a new application has created a new database « newdb » and, for
differents reasons, the program has created again  the « john » login
(same name)

Now, I can Access with this login to the database « newdb » but no more
to the default one « mydb ».
When I say « i can Access... »that means :

Select * from toto is working on « newdb »
(I dont need to write Select * from john.toto)

But with « mydb »,

Select * from toto does not work,
I need to write the select this way :  Select * from john.toto
Since I use an application, I cannot change the sql statement

since john is "dbowner" and has a defaut db "mydb", this is strange

When I read master.dbo.sysusers, the user « john » has a complexe SID  
(« 0x93F921DB3.... »)

When i read master.dbo.sysdatabases :
The new database « newdb » has the same complexe SID (« 0x93F921DB3....
»)
The old database « mydb » has lost the SID witch is replaced with  « 0x01
»

The table toto has the correct UID that is « john » in sysusers table

How can I « reset » "john" owner on all tables from mydb

many thanks
nicolas