OS: Windows Server 2003 R2
SQL Server 2005 SP4
This server as been brought to current DISA and STIG requirments. I belevie the issue is when I revoked public and Guest. I also moved those same premissions to a DB Role. After completing this task a created a user database and then created a user. when creating the user I went through the in the user mapping pain. I granted this user access to master which is a requirment, then gave him db onwer and set is default schema to dbo. When this user goes into SSMS they can only see the master datadase.
How do I make the user databases show up for the user to use.