From the course: SQL Server: Security for Developers

Unlock the full course today

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

Demo: Building custom roles

Demo: Building custom roles - SQL Server Tutorial

From the course: SQL Server: Security for Developers

Start my 1-month free trial

Demo: Building custom roles

“

- [Instructor] In this demo, we're gonna do a couple of different things, the first thing we're gonna do is create a log-in for our level one DBA team, and we're gonna create a server role, and add some permissions to it, we'll walk through how that works, we'll change log-ins, and then the second thing we're gonna do is a more traditional, creating a database role, and granting access to a specific object to a user, and we'll see how that works as well. So here we're creating a log-in for our level one DBA team, so this is just a standard, create log-in script, and we'll go ahead and run this, and there we see that created successfully. And next, we're gonna go ahead and do a couple of different things here, we're first gonna create the role, and then we're gonna add the DBA team to that role, and then we're gonna grant a couple of system permissions, so, the grant here, review any database, so this will allow them to see any database, and view server state, which will allow them to…

Contents