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)
This is easy,
Down Red Arrow means disabled, like every one mentioned in their replies.
Starting SQL Server 2005, Microsoft disabled Guest account in msdb and model database for security reasons and all sample databases.
This account will still be enabled in master and tempdb database.
For Security reasons, it is advised that guest account is disabled in user databases and public role should not be given access to any object in any database.
Excellent Answer Imran!
Red arrow signifies login is disabled..
Login is disabled..
“The Hidden Tiger”:
I found hidden tiger , which is exactly above the visible tiger inside the image..
The one tiger standing and looking at front actually looking the other tiger and only the shadow of other tiger is there.
User guest is denied to connect to the database adventureworks.
grant connect to guest;
This will resolve the problem.
Good one Pinal.
I started to worry when saw only 5 at the first time.
Thanks Pinal, Question: When you buy SQL License do you look at this value? if not then what should we look to buy SQL License appropriately?