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 select okay on here,…notice that we`ll be dealing with permissions…