user's list of web sites in SharePoint - Sharepoint

I'm not sure if this will work on 2003 (haven't got a setup), but you
could probably mod the below to work.

SELECT DISTINCT w.Title, r.WebId, r.Title AS accessLevel, ui.tp_Login,
ui.tp_DomainGroup, ui.tp_Title, w.FullUrl, w.AlternateCSSUrl,
p.ScopeUrl
FROM RoleAssignment AS ra INNER JOIN
Roles AS r ON r.SiteId = ra.SiteId AND r.RoleId
= ra.RoleId INNER JOIN
UserInfo AS ui ON ui.tp_SiteID = ra.SiteId AND
ui.tp_ID = ra.PrincipalId INNER JOIN
Sites AS s ON s.Id = ra.SiteId INNER JOIN
Perms AS p ON p.SiteId = ra.SiteId AND p.ScopeId
= ra.ScopeId INNER JOIN
Webs AS w ON w.Id = p.WebId

You can do a union with the other wss_content DB's.


R.

On Jul 6, 1:51 am, apondu <apo...@gmail.com> wrote:
> Hi,
>
> i had a query on sharepoint portal 2003 and i am using VS2005 C#.Net.
>
> We know we can get the users of the web sites in the sharepoint, but i
> have a different
> query now, we know tht we can synchronize Active Directory Services
> with SharePoint.
> Now taking a user from Active Directory Services, i want to get the
> list of all websites in sharepoint
> to which he is a member, he can be either a Reader, Contributoe,
> Administrator.. doesn' matter
> but if he a member then we have to list that website.
>
> Can anyone help me to achieve this.
>
> Waiting for ur responses
>
> Thanks for the response.
>
> Regards,
> Govardhan

On Jul 7, 1:39 am, KoliPoki <ray...@gmail.com> wrote:
> I'm not sure if this will work on 2003 (haven't got a setup), but you
> could probably mod the below to work.
>
> SELECT DISTINCT w.Title, r.WebId, r.Title AS accessLevel, ui.tp_Login,
> ui.tp_DomainGroup, ui.tp_Title, w.FullUrl, w.AlternateCSSUrl,
> p.ScopeUrl
> FROM RoleAssignment AS ra INNER JOIN
> Roles AS r ON r.SiteId = ra.SiteId AND r.RoleId
> = ra.RoleId INNER JOIN
> UserInfo AS ui ON ui.tp_SiteID = ra.SiteId AND
> ui.tp_ID = ra.PrincipalId INNER JOIN
> Sites AS s ON s.Id = ra.SiteId INNER JOIN
> Perms AS p ON p.SiteId = ra.SiteId AND p.ScopeId
> = ra.ScopeId INNER JOIN
> Webs AS w ON w.Id = p.WebId
>
> You can do a union with the other wss_content DB's.
>
> R.
>
> On Jul 6, 1:51 am, apondu <apo...@gmail.com> wrote:
>
>
>
> > Hi,
>
> > i had a query on sharepoint portal 2003 and i am using VS2005 C#.Net.
>
> > We know we can get the users of the web sites in the sharepoint, but i
> > have a different
> > query now, we know tht we can synchronize Active Directory Services
> > with SharePoint.
> > Now taking a user from Active Directory Services, i want to get the
> > list of all websites in sharepoint
> > to which he is a member, he can be either a Reader, Contributoe,
> > Administrator.. doesn' matter
> > but if he a member then we have to list that website.
>
> > Can anyone help me to achieve this.
>
> > Waiting for ur responses
>
> > Thanks for the response.
>
> > Regards,
> > Govardhan- Hide quoted text -
>
> - Show quoted text -

Not recommended to select directly from the databases as you can
violate the locking hierachy and damage performace. Better to use the
object model to do this.

Richard