How to configure access permissions for a new user on a SQL server
We use cookies to make your experience of our websites better. By using and further navigating this website you accept this. Detailed information about the use of cookies on this website is available by clicking on more information.
Accept and close

 

 

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
 

 
 

Feedback on Technical Support Site

Please let us know what you think about the site design, improvements we could add and any errors we need to eliminate

Send My Website Feedback Send My Website Feedback

Thank you!

Thank you for submitting your feedback.
We will review your feedback shortly.

 

How can we improve this article?

We will not be able to contact you if you leave your email address or phone number. To contact technical support, please sign in to your Personal Account.

Submit Submit

Thank you for your feedback!

Your suggestions will help improve this article.

OK