How do you add or remove shell access to a web apps content databases?
This script will grant shell access to a user on all the content databases associated with a content database.
$contentDbs = Get-SPContentDatabase -WebApplication "http://yourSharePointWebApp.com/" foreach($db in $contentDbs) { Add-SPShellAdmin -UserName "domain\user" -database $db }
Remove shell access
$contentDbs = Get-SPContentDatabase -WebApplication "http://yourSharePointWebApp.com/" foreach($db in $contentDbs) { Remove-SPShellAdmin -UserName "domain\user" -database $db }
After running the remove script, make sure you check the WSS_Admin_WPG and WSS_WPG groups on the servers in your farm.