MSSQL 2008 Management studio

you would need to revove the permission 'VIEW ANY DATABASE' from the role PUBLIC

can be my connection is not right to the server ?
i write under Management stuido connection:

databankmodul
servername     ------ may be here only database 3 should write?
windowsauthentication
domain\user
password

how can i connect direct to database 3?

servername->          servername\003

Hm this does only work, for me, on a locally installed database. Not over the network.

any way Its not working servername\003

I tried. Only works locally yes.

Did you remove the VIEW ANY DATABASES from the PUBLIC role?

can you please tell me how can get this? 'VIEW ANY DATABASE' from the role PUBLIC

because i can find.
My problems is I have many databases on my msqlserver ,i do not want new user to see all

Under security, logins. Double click the user and go to securables.

Under the tab EFFECTIVE you probably now see, SQL Connect and VIEW ANY DATABASE.


Configure like above and press apply.
Check tab Effective again and VIEW ANY should be gone.

sorry for many questions:

Under security --- mean under database 3 ?

Nope under general security.


Next you can check if this user if listed under database 001 and 002 (database-security) and if it is present delete the user there.

Under the tab EFFECTIVE you probably now see, SQL Connect and VIEW ANY DATABASE.--i did

super now all databases not shows -But how can i db 3 connecr because its not showing too.

Is the user there under 003/security/login?

yes he is under 003 db, login is no problem ,but only cant see 003 bd and no others too offcourse

what i did:
1.new user login created under db 003(security/login)
2.new user login created under databases(security/login)
        Under the tab EFFECTIVE you probably now see, SQL Connect and VIEW ANY DATABASE
--- i  did deactive.
then SUPER! user can login but no can see all databases--THIS IS WHAT I WANTED.

only think he has to see only db 003 but not

Thank you so much

Did we solve the problem?

no, user still cant see db 003

unfortunatlly no success---USER LOGGED

ADMIN LOGGED

Is user dbo for 003?

yes

under 003 db -security -login-username-properties- standarschema for user dbo

Strange.. if he is owner he should see his database.

Can you restart SQL server and check or maybe post a screen for the roles of this user?

unfortunatly now i cant because people use .But today night i can do that.

today i will do that

after new start the server no changes ,still user cant see 003 db