Recently I received an empty email with the subject “Question for you”. I was bit surprised as the email had no content at all. It was absolutely empty. I wrote back to user asking if he has missed the text in the email. He responded that there was an image already attached to the email and I needed to “enable display image in the email.” When I did the same, I found following image and the question from a user was inbuilt the image as well.
The question was in database property what does Restrict Access = Restricted_User means? It is very clear to all of us what Multi_User is and what Single_user is. However, the real question was what Restricted_User stands for. As the question was sent in the form of image, I had decided to answer the same with the help of the image as well.
I quickly created following image and sent back in reply.
In database property what does Restrict Access = Restricted_User means that database can be accessed by users with sysadmin and dbcreator server roles and db_owner database role. After I sent the email, I really thought, it was a quite different type of communication and hence I am blogging the same over here.
Reference: Pinal Dave (http://blog.sqlauthority.com)