Developer forum

Forum » Development » How to get all Extranet Groups from AccessUser

How to get all Extranet Groups from AccessUser

E-mail notifications
Sebastian Dammark
Reply
Posted on 05/12/2012 10:34:53

Hi Folks

I've got an old AccessUser database and I want to get all Extranet Groups.
But I can't quite remember how I see the difference between User Groups and Extranet Groups ?

// Sebastian Dammark - Former DW Employee


Replies

 
Morten Bengtson
Posted on 05/12/2012 11:17:42
Reply
This post has been marked as an answer

Hi Dammark, old friend... still trying to hack Dynamicweb? :)

 

The group/user type is stored in the AccessUserType column in the AccessUser table.

To get a list of all extranet groups you can use this...

SELECT * FROM AccessUser WHERE AccessUserType = 11

Here is a list of the different types...

 

Groups
2 Default
11 Extranet / HR

 

Users
1 SystemAdministrator
3 Administrator
4 Editor
5 Default
15 Extranet / HR

 

Hope this helps.

 

// Morten Bengtson - Former DW Employee ;)

 

Votes for this answer: 1

 

You must be logged in to post in the forum