DNN Permission Issues with Child Portal in DNN 5.5.+ (up to 5.6.0) and a Fix


I wrote a post last month to fix the permission issue after a child portal is created with DNN 5.5+ (upto 5.6.0)

https://jingyangli.wordpress.com/2010/12/02/dnn-sercurity-setting-locked-issue-dnn-5-5-0-and-dnn-5-6-0/

There is another issue related to the permission during the child portal creation. I have an updated script to fix the issue with the DotNetNuke control panel shows for all users in the child portal.

Here is the script:

(Before try the script, Backup your DNN database!)

 

use  
myDB
GO 

–Edit Ribbon show for all users
–Remove the entry
–Created by Jingyang Li 01/07/2011 
 
DELETE FROM
 dbo.TabPermission
WHEREpermissionId=4 and RoleId=-1
Go
   
–Fix Edit function after child portal created
–Created by Jingyang Li 12/2/2010
 
 
UPDATE  p  SET p.AdministratorRoleId=d.AdministratorRoleId,
 p.RegisteredRoleId =d.RegisteredRoleId FROM ( SELECT PortalID, [Administrators] as AdministratorRoleId, [Registered Users] as RegisteredRoleId  
FROM (SELECT PortalID, RoleID, RoleName from roles ) src
 PIVOT  (MIN(RoleID) FOR RoleName IN ([Administrators],[Registered Users]))pvt
)
  INNER JOIN  dbo.Portals p ON d.PortalID=p.PortalID
 
GO
 
 
Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s