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.
1 2 3 4 5 6 | $contentDbs = Get-SPContentDatabase -WebApplication "http://yourSharePointWebApp.com/"foreach($db in $contentDbs){ Add-SPShellAdmin -UserName "domain\user" -database $db} |
Remove shell access
1 2 3 4 5 6 | $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.