I have imported a newer version of the existing database.
It contains a user (say user1) in the source system which is shipped on the new computer but I am unable to open the database base (object explorer) to see the objects.
What missing is may be the rights to connect the user to that database.
When I have checked the user details in the security>Logins>Login Properties> Login Properties (object explorer) user name is not mentioned against the database as it is in the server from where I have took the backup.
Please let me know conceptually what I am missing and what’s I am suppose to do. Further information is that this user has execute rights on some procedures of that database but not anything other than that.
View Complete Post