Watching Grant DB Permissions

This is a beautiful bit of script that allows you to set DB permissions for a user. This is particularly useful for adding a user to multiple DBs on the server. And the code to accomplish this is much shorter than its T-SQL counterpart. If you need a bit more explanation about how this is put together then look at the video for granting schema permissions with Powershell.

 

Author: Sean McCown

Filmed: 9/17/2008

Length: 9:28 minutes

Size: 18,824 KB

Click here to download the video!