How to configure access permissions for a new user on a SQL server

 

Kaspersky Security 8.0 for SharePoint Server

 
 
 

How to configure access permissions for a new user on a SQL server

Back to "Technical articles"
2012 Nov 19 ID: 7995
 
 
 
 

Applies to Kaspersky Security 8.0 for SharePoint Server

Use the following PowerShell command to add all the required SQL permissions to a new user:

Get-SPDatabase | ?{$_.Name -eq "WSS Content"} | Add-SPShellAdmin –Username domainname\UserName

This command adds the domainname\username user into the SPShellAdmin role of the WSS Content base. It also creates Database Roles named SharePoint_Shell_Access for the new user.

You should repeat the same command with different base names (WSS Content in our example) for all the Content databases created on Microsoft SharePoint Server.
 
 
 
 
Was this information helpful?
Yes No
Thank you
 

 
 

How can we improve this article?

Your feedback will be used for content improvement purposes only. If you need assistance, please contact technical support.

Submit Submit

Thank you for your feedback!

Your suggestions will help improve this article.

OK