Home
Blogs
DBAs@Midnight
Admin
Dev
Midnight Snacks
All Vids
Events
Contact
Links
NTSSUG

Leave a comment.

Name:
Email:
Comment:
(500 chars.)

0 of 500.
What's the picture?



Grant DB Permissions


Author: Sean McCown
Date: 09/17/2008
Length: 9:28
Size: 18,824 KB

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.

Right-click to download video

Others in Series:

You might also like:

Monitor Backups with Powershell
Scripting DB Objects in PowerShell
Building a Powershell BCP Routine
Server Properties
PowerShell Basics