From the course: SQL Server 2016: Administer a Database Infrastructure
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Manage database object permissions - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Manage database object permissions
- [Narrator] Once users have access to a SQL Server instance and the databases with it, their ability to perform required tasks should be assigned carefully. While individual permissions can be assigned to each individual table, it's often a much better approach to use database roles instead. By default, users begin with only the permissions granted to the public role, which isn't very many at all. To do anything useful on the database, they'll need to be given the ability to perform tasks. To manage permission SQL Server uses three permissions statements that pair a user with an ability. The permission statement, grant, will give the user abilities to carry out specific tasks. The revoke permission statement will remove a users' ability to execute the task. If a user is issued both a revoke and a grant, through different group memberships, then the grant permission will override the revoke. And the user will still be able to perform the task. And finally, there's the deny permission…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.