sharepoint security groups, ACL of site collection or subsite need to move in to sql server 2008 using c#
HI Team, I am new to sharepoint here is my query. i am working on MOSS 2007, SQL server 2008 I want to move the sharepoint security groups, ACL(access control list), user groups all the security and permission related data to sql server 2008 from a particular site collection or subsite. After getting the data in to sql server we should be able to update the users from sql server itself which should reflect in sharepoint sites.
October 23rd, 2010 2:36pm
Security groups for SharePoint are already stored in the SharePoint SQL databases. Moving them to a different SQL database is not a good idea and will void your warranty with Microsoft. SQL databases in SharePoint shouldn't be directly modified in any way ever. You can update users and their permissions directly using the SharePoint API's. That would be the correct way to write code to managed the user permissions.Paul Stork SharePoint Server MVP
October 23rd, 2010 11:12pm
Hi paul, Thanks for your reply. I am doing a POC on moving security groups, ACL(access control list) to a external sql server database.i am asked to use sharepoint webservices and object model in c# to get the security group data in to external database for a site collection. do you know which sharepoint webservices i can use in my case.
October 24th, 2010 3:06pm
I am not aware of any webservices built-in to SharePoint that expose security. For one thing SharePoint doesn't use ACL's in the way that you are thinking. Objects like SPSite, SPWeb, SPList, and SPItem are either set to inherit permissions from their parent object or maintain their own permissions via a collection of objects called SPRoleAssignment objects. You would need to write your own web service from scratch to export SharePoint security settings to a database.Paul Stork SharePoint Server MVP
October 24th, 2010 3:32pm
Hi Paul, sorry for my misunderstanding I am asked to get usergroup data and info of a particular subsite in to sql server database. i had gone through usergroup.asmx in msdn hopefully i will be able to get it done.
October 25th, 2010 1:29pm