This project has moved and is read-only. For the latest updates, please go here.

Import existing users

Sep 23, 2014 at 4:17 PM
Edited Sep 23, 2014 at 4:41 PM
I am trying to import existing fba users to the aspnetdb. How i can import sitecollection permissions for the fbausers. In which tables i can find the site collection permissions for fbausers. Do we have any script to add all users permissions to the new site collection. Please help...
Sep 23, 2014 at 5:16 PM
Import them from where? All the permissions are set in SharePoint, so I'd say in most cases you'd have some SharePoint groups setup that would have the appropriate permissions and you'd just add the users to the groups.

If you want to copy permissions from one site collection to another, there's some info here:

http://social.msdn.microsoft.com/Forums/office/en-US/25e54544-bf02-4861-af6d-a8a308c58b34/copy-permissionsroleassignment-across-site-collections?forum=sharepointdevelopmentlegacy
Sep 23, 2014 at 5:35 PM
i have more than thousand users in existing sharepoint aspnetdb. I imported all users to aspnet_membership and aspnet_users table, but i don't know how i can import sharepoint groups from existing sharepoint Database. Do we have information about which user belongs to which group. Do we have any easy way of adding users to the group.
Sep 23, 2014 at 7:04 PM
Usually different site collections have different permissions assigned. If it's the same site collection, why not just restore or import the site collection which will import all of the site permissions:

http://sharepointsolution2010.blogspot.sg/2011/09/import-and-export-sites-on-sharepoint.html

If you don't want to do an import, here's a powershell script that might get you started:

http://social.technet.microsoft.com/wiki/contents/articles/14242.sharepoint-2010-export-all-unique-permissions-from-site-collection-using-powershell.aspx