I has a db [db01], user_01 has dbo permission on this db. everything works fine.
and later on, i added a new db [db02]. i creaed another user [user_02], and made user_02 the dbo pn this db. user_01 has no permission on the new db.
right now, user_01 complaint, when he connect to sql server by SSMS, he got connected by his security context. but, when he click on the [databases] from the [object explorer] to see the full list of database, he got error message 'the server principal 'user_01' is not able to access the database [db02] under the current security context. (microsoft sql server, error: 916)
please help.
_______________________________________________________________