December 7, 2005 at 12:15 pm
Hi All,we've a SQL server 2000 setup and content db's are created using windows share point services.(No db's are created directly using EM)we've different db's for different site collections.I want to pull out some information of a particular user regarding as to which sites the user is an adminstrator of.i'm trying to frame a query,but it returns a cartesian product.I'm not sure which table has the info in it regarding the rights of the users..does anyone have a similar setup and help me in this..?Thanks,AK.
December 7, 2005 at 7:22 pm
Unless I'm mistaken, this information isn't stored in the collaboration database. I'm not a Sharepoint or Sharepoint Services expert, so take what I'm about to say with a grain of salt. I believe the information on roles is stored in local groups on the web server itself. They would be of the form OWS_<some number>_admin. The description of the group will tell you to what site the group corresponds to.
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply