We are using the Microsoft SQL forms provider to grant access to external users on a SP2010 Enterprise server.

We have installed a codeplex solution "SharePoint 2010 FBA Pack" that allows us to manage the FBA users from our root site collection.

I now need to find out which FBA users have access to certain roles but I cannot seem to find out any easy way as under role management it just gives a number of users in the role and does not show the users names.

If anyone has any experience with this codeplex solution or know of a query that can be performed on the SQL FBA database that can return the information required that would be useful.


SharePoint does not give you a site in the GUI, which permissions have been assigned to a specific user. It does not matter if this user is a FBA- or Domain-Account.

You have to navigate manually to each page and check permissions there. 3rd party tools or PowerShell might help you out.

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.