First of all Merry Christmas and Happy Holidays to everybody. I wish you best holiday season.
In today’s blog post – I am sharing very small question received by one of the reader. Though simple sometime a small question make people think. He sent me very similar to following image and asked few questions. As his image represented his server’s information, I am reproducing very similar image using AdventureWorks database.
Question: What does the number of users signifies in database properties? Does this mean current connected users or total active users or total enabled users or what exactly?”
Answer: Database Properties >> Number of Users indicates the how many users exists in the database.
In my current example you can see that there are 5 users and that is displayed in the above properties screen. Though, it is very simple question, now I am going to ask you question back.
Question to readers: If you notice there is small arrow besides GUEST or SYS login. It is RED arrow on south. What does this arrow means?
Please leave your answer in comments area.
Reference:Â Pinal Dave (https://blog.sqlauthority.com)
29 Comments. Leave new
Means that user is disabled for using that database Pinal :)
Hi Pinal
Small down arrow represents that the specific user is disabled
which means the Status of those Logins are Disabled.
Hi Pinal,
Red arrow indicates that specific login is disabled.
A user inside a database with an red arrow down is one that does not have CONNECT rights to the database.
Hi Pinal, it means that the user is disabled.
Dear Pinal,
Please correct ‘Marry Christmas’ to ‘Merry Christmas’.
Regards
Ashish Kolarkar
Red arrow means the particular user is inactive.
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]
Red arrow means user is inactive/disabled
It’s means that the user doesn’t have permission to connect to the database.
To grant access to that particular user you have to execute this query
GRANT CONNECT TO guest
to revoke that permission you have to execute this query
REVOKE connect TO guest
That guest user is disable for database. That means no other user uses that database with the property of guest access. pinal :)
The red “down” arrow indicates that the login is not available, i.e. disabled.
Merry Christmas, everyone!
Hi Pinal
Small Red Colour Down arrow represents that the specific user account has been disabled.
Gopalakrishnan Arthanarisamy
Unisys, Bangalore.
This red arrow show that currently use is disable.
The use with red down arrow means user is disabled.
It becomes red when the security entity does not have connect permissions on the database.
it means that user is disabled
It signifies that the user is disabled.