O'Reilly logo

Writing Stored Procedures for Microsoft SQL Server by Matthew Shepker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required