Some questions are very open ended. Here is one question I was asked in recent User Group Meeting about user without login.
SQL SERVER – Beginning of SQL Server Architecture – Terminology
SQL Server Architecture is a very deep subject. Covering it in a single post is an almost impossible task. However, this subject is very popular topic among beginners and advanced users. I have requested my friend Anil Kumar, who is expert in SQL Domain to help me write a simple post about Beginning SQL Server Architecture. As stated earlier, this subject is very deep subject and in this first article series he has covered basic terminologies. In future article he will explore the subject further down.
SQLAuthority News – 2 Security Updates for SQL Server 2000 SP 4 Users
If you are using SQL Server 2000 still today my very first recommendation to you is to upgrade to SQL Server 2012. SQL Server 2000 is now 12 years old product and since then many new enhancements as well features which are relevant to current growth and progress in Informational Industry.…
Read More
SQL SERVER – Beginning of SQL Server Security
Security is a very important concept and no matter how many times we discuss this it is never enough. I have requested my friend Bharti who is expert in SQL Domain to help me write a simple post about beginning SQL Server security.
SQL SERVER – Solution – User Not Able to See Any User Created Object in Tables – Security and Permissions Issue
There is an old quote “A Picture is Worth a Thousand Words”. I believe this quote immensely. Quite often I get phone calls that something is not working if I can help. My reaction is in most of the cases, I need to know more, send me exact error or…
Read More
SQL SERVER – Introduction to SQL Server Security – A Primer
Let’s get some basic definitions down first about SQL Server Security. Take the workplace example where “Tom” needs “Read” access to the “Financial Folder”. What are the Securable, Principal, and Permissions from that last sentence?
A Securable is a resource that someone might want to access (like the Financial Folder).
A Principal is anything that might want to gain access to the securable (like Tom).
A Permission is the level of access a principal has to a securable (like Read).
SQL SERVER – guest User and MSDB Database – Enable guest User on MSDB Database
I have written a few articles recently on the subject of guest account and MSDB Database. Here’s a quick list of these articles:
SQL SERVER – Disable Guest Account – Serious Security Issue
SQL SERVER – Force Removing User from Database – Fix: Error: Could not drop login ‘test’ as the user is currently logged in.
SQL SERVER – Detecting guest User Permissions – guest User Access Status