@ Sebastian

Re read through the entire thread, at your post above with link to Turbo Scripts realized that the script I had run for the exception was not a Turbo Script [Fix DNN Roles - Version 0.9.5 (2014-10-06)].

Have downloaded and run the Turbo Scripts. Problem fixed. Thanx

 

In case folks are still struggling with "Managed Service" not showing publicly available security roles (this bug is still in DNN8 releases):

Sebastian Leupold gave me a SQL to fix the problem of "security roles" not showing up under "Managed Services"

Backup the app/database first... then go to Host > SQL and enter...


IF EXISTS (SELECT * FROM sys.Procedures WHERE object_id = OBJECT_ID(N'{databaseOwner}[{objectQualifier}GetServices]'))
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetServices]
GO

CREATE PROCEDURE {databaseOwner}[{objectQualifier}GetServices]
@PortalID Int, -- pass Null for roles of all sites
@UserID Int -- not null!
AS
BEGIN
SELECT
R.*,
UR.IsOwner,
UR.UserRoleID,
UR.UserID,
UR.ExpiryDate,
UR.IsTrialUsed,
UR.EffectiveDate,
U.DisplayName,
U.Email
FROM {databaseOwner}[{objectQualifier}Users] U
INNER JOIN {databaseOwner}[{objectQualifier}UserRoles] UR ON UR.UserID = U.UserID AND (UR.UserID = @UserID OR UR.UserID IS Null)
RIGHT JOIN {databaseOwner}[{objectQualifier}Roles] R ON UR.RoleID = R.RoleID
WHERE (R.PortalId = @PortalID OR IsNull(@PortalID, -1) = -1)
AND R.IsPublic = 1
AND R.RoleId >= 0 -- DNN-4288: hide system role atm to prevent duplicates. Might be removed, after API has been adopted
ORDER BY R.RoleName
OPTION (OPTIMIZE FOR (@PortalID UNKNOWN));
END -- PROCEDURE
GO

You should see in the green bar at the top of the page that the script ran successfully... so then log out, and log back in as a register user and navigate to Manage Services and see if you can see the security roles.

---