From the course: SQL Server 2008 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Introduction to SQL Server security and permissions

Introduction to SQL Server security and permissions - SQL Server Tutorial

From the course: SQL Server 2008 Essential Training

Start my 1-month free trial

Introduction to SQL Server security and permissions

“

Here's what the SQL Server understands about security. It knows you make a database because you want to people to use it. There are users and groups of people. There are Web applications and desktop applications that want what it is you have in your database. The SQL Server calls these principals. A principal is something that will connect to SQL Server to request a resource. They'll select from a table or update a table, or execute a stored procedure, or even create a database. And on the other end SQL Server knows about the things that exist inside of it. The databases, the tables, the stored procedures, the functions, the schemas, the views, all these things we have worked with our considered objects in SQL Server. And yes, many objects contain other objects. Databases contain schemas. The schemas contain tables and stored procedures, and so on. But just because a principal can get into SQL Server at all doesn't mean that it should have blanket access to use and change and control…

Contents