Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
opowell
Starting Member
12 Posts |
 Posted - 2011-02-17 : 10:13:23
|
| OS: Windows Server 2003 R2SQL Server 2005 SP4Enviorment meets STIG Requirments. OK I have a new one for me. Lets start with some background. The SQL Server enviroment meets most if not all DISA/STIG requirments. AS in Public and Guest Premissions have been revoked. I have also created DB roles and gave what was those public premissions to the new role.ISSUE: I have created a new user and through the User Mapping I have granted this user dbowner, and giving him dbo as default schema. Once this user as logged into SSMS all he can see is the master database which is needed for connections.How do I get this user to see the user database that show him as dbowner. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-02-17 : 11:35:24
|
| read this |
 |
|
|
|
|
|
User Can not see user databases in SSMS