As shown in figure, used to give the user a database query, the database using the user login not show

CodePudding user response:

With sa first login to perform the following SQL, then use the test try to login again.

 
Use [projects] 2021 

If the exists (select 1 from sys. Sysusers where name=N 'test') 
The begin 
Drop the user test 
End 

The exec sp_changedbowner test