I am using SQL Server 2005.
I set up a new user on my development SQL Server, and made him an owner on a specific database. I can log in as him, see all the databases, and open only the database specified.
I set up the user on my production SQL Server using the same exact procedure (set as owner on a specific database), but when I log in as him I cannot see any databases listed. What can I do to fix this?