What is the signifigance of the user Icon in SSMS DB users node with the red down arrow?

Question

SQL BOL documentation is sorely lacking in this area, or I just haven't found the magic words to find such explinations.  It amazes me when developers come up with a "cool new icon" to signify something and then don't bother documenting what the heck it means!

So, in general, has anyone found a CENTRAL reference of icon descriptions for SSMS?

Answer 1

Dwaine,

User Red Arrow down means Login Disabled.

(partial answer)
Execution plan icon link: Graphical Execution Plan Icons (SQL Server)

You may want to drop a note to the SQL Server Team at: https://connect.microsoft.com/SQLServer?wa=wsignin1.0

---

Kalman Toth
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2016

Answer 2

Just as a clarification, a login with a red arrow down is a disabled login, and a user inside a database with an red arrow down is one that does not have CONNECT rights to the database.  This can be fixed with the following grant statement:

USE DatabaseName
GO

GRANT CONNECT TO [Username]

 

 

 

Answer 3

it doesnt work, please help