Fantastic! How could I not know I have been balancing so close to my maxim "Oh, this is for others, for me Unicode is about the same as ASCII; longer?...

I suppose that any application (Mgmnt Studio included) takes databases list from sys.databases, and it is this place where unaccessible databases are expected to be excluded from.

Well, db naming conflicts...

Thanks, RBarryYoung.

This had been my conclusion, and having been discontented with it I initiated this thread. I thought I was missing something. The requirement looks so natural, and I --...

Let me rephrase my question.

I am a system administrator and my login is "sa".

sa login owns database [pacrat]

What TSQL command(s) should sa execute in order to make a given database,...

revoke view any database to public

create login te0507 with password='111111'

Now my login te0507 cannot see a single user database name (the two sytem databases apart).

[font="Courier New"]

select name from sys.databases

name

--------------------

master

tempdb

(2 row(s)...

>>By granting privileges the right way.

Now I know I was wrong when I thought "by granting pivileges the wrong way."

>>How are they seeing Databases that they do not have any access to?

Easy, please see the attached image.

My question is: "Is it possible and if yes, what needs to be...