From the course: Microsoft SQL Server 2016: Installation and Administration

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Implement database permissions

Implement database permissions - SQL Server Tutorial

From the course: Microsoft SQL Server 2016: Installation and Administration

Start my 1-month free trial Buy for my team

Implement database permissions

“

- [Instructor] Applying permissions at a database level allows you to specify what users can and cannot do on an individual database. Expanding the security folder for the database and coming into the users folder, find the user that you're interested in applying the permissions to and double click to open the properties for that user. You'll typically end up going to the securables tab to modify the permissions that a user has on a specific database and or schema. You can see that test user one already has some specific permissions set on a human resources schema and a table in that schema called department. The permissions that the user has currently we can see by the check boxes. So, alter has been granted, control has been granted, and so has insert. We can apply the different securables by choosing the search button, looking for a specific objects or all objects of a certain type, choosing okay, it allows us…

Contents