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

Unlock the full course today

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

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

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 then to select a specific object. We can choose databases and if I…

Contents