Hi,

I'm trying to retreive a list of all authorised users in a specific portal. I note there is a view called vw_Users which I initially I thought might do the trick e.g.

SELECT     dbo.vw_Users.*
FROM         dbo.vw_Users
WHERE     (Authorised = 1) AND (PortalId = 0) --where 0 is the id of the portal I'm interested in

however I'm a bit confused when it comes to Host Accounts. I noted that when I added a new host account (using the Host Settings -> Host Accounts tab) that I could specify whether or not to Authorize the new host account. To test if things were working as expected I went through the process of authorizing and un-authorizing the new host account, however when I ran/refreshed vw_Users, the Authorised column was always set to NULL irrespective of the current status. I verified that I had authorized and unauthorized the new host account correctly by trying to login and sure enough I couldn't login when the host account was unauthorized (as expected). Am I missing something? How do I retreive a list of authorised users only that includes authorised host acount users only? The following query includes the unauthorised host account

SELECT     dbo.vw_Users.*
FROM         dbo.vw_Users
WHERE     (Authorised = 1) AND (PortalId = 0) OR
                      (IsSuperUser = 1)

(I note that the PortalId column is always NULL for host users so I guess host accounts are not associated with any one particular portal (i.e. they can access all portals) - i.e. I can ignore that column in my query)

Thanks

Thanks for the reply