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.