default setting for login to access database
Posted on 2010-09-17
when i try the below:
CREATE LOGIN test WITH PASSWORD='test', CHECK_POLICY = OFF
execute as login = 'test'
use ROSE_IT --works ok
use tracker -- says "The server principal "test" is not able to access the database "tracker" under the current security context."
why is that one database acts differently than the other. what setting is that?