SQL Server Security
As a part of any real relational database management system, the ability to control who has access to what data is very important. There is certain data that you want only a couple of people to see. Whether it's company confidential information such as product formulas and client lists or HR data such as salaries, you have to be able to control who sees what. SQL Server enables you to do this through the use of logins, users, roles, and permissions.
Logins
A login is the first step to gaining access to a SQL Server. A login ID is the credential you must supply to the SQL Server when you try to establish a connection. If the SQL Server can't verify the supplied login ID, the connection is refused and the person trying to access ...
Get Writing Stored Procedures for Microsoft SQL Server now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
