I would like to list all the users who have specific rights to a custom module.
My first thought is to create a SQL procedure and pull the data directly from the "ModulePermission" table. This table could be changed in the future so I would prefer to use existing DNN controls if they exist.

Some of the functions in "DotNetNuke.Security.Permissions.ModulePermissionController" look promising but I can't find any information on what these functions return.

Any help is appreciated.

Actually I am trying to retrieve all users with a custom permission. Custom permissions are discussed here:

http://www.dotnetnuke.com/Community/Blogs/tabid/825/EntryID/1052/Default.aspx

But if you know of a way to list users with view or edit permissions, that information would be appreciated.

 

I recently had to do this in a custom module for which a custom permission key "MODERATE" had been defined. Here's a snippet of code which fills an array list with ListItem objects containing the username/userID of those with "MODERATE" permission on the module:

Dim arrAvailable As New ArrayList
 Dim mpc As New DotNetNuke.Security.Permissions.ModulePermissionController
 Dim rc As New DotNetNuke.Security.Roles.RoleController
 Dim mp As DotNetNuke.Security.Permissions.ModulePermissionInfo
 For Each mp In mpc.GetModulePermissionsCollectionByModuleID(ModuleId, TabId)
       If mp.PermissionCode = Permission.Code And mp.PermissionKey = Permission.ModerateKey Then
              Dim RoleName As String = mp.RoleName
              For Each ui As Entities.Users.UserInfo In rc.GetUsersByRoleName(PortalId, RoleName)
                     Dim li As New ListItem(ui.DisplayName, ui.UserID)
                     If Not arrAvailable.Contains(li) Then arrAvailable.Add(li)
              Next
       End If
 Next

In the above code, Permission.Code and Permission.ModerateKey are string constants, "WESNet_EPrayer" and "MODERATE" representing the defined custom PermissionCode and PermissionKey. An ArrayList of ListItem objects were used because in the following code those already actively assigned as Moderators are removed from the ArrayList then those remaining are used to populate a DropDownList of moderators still available to be assigned.

---

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner