I am having copy of content database from client. Now i need to find permission level for particular user using SQL query. Is it possible?

  1. First of all never query content database. You will end up violating your license.

  2. Restore the content database and attach it to a web application.

  3. Use Powershell or Visual Studio to write a small piece of code to query the SPSite object against the user who permissions needs to be identified.

I would recommend to go for this simple powershell script available in codeplex that will suffice for the requirement you mentioned.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.