sub-nodes and contents access authorization

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

This thread is closed to new posts. You must sign in to post in the forums.
10/11/2009 10:23:56 AM
locutusdiborg
Gravatar
Total Posts 7
View Posts

sub-nodes and contents access authorization

Hello, I have this "problem".

While I was developing my site, I create the content under administrators only access, so that not registered user cannot see the content.

Now I want to switch the autorization for all the nodes and item to all users. The problem is that if I switch the authorization on the parent button (in the navigation pane), not all the nodes switch. Is there a way to change all the authorizations to "all users" in one click? Also some "html content" are admin only (while google maps are not) and I havent set them to be admin only.

Thank you!

10/12/2009 2:43:33 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: sub-nodes and contents access authorization

Hi,

Sorry but I have no easy solution for this.

You could possibly run a database query to change the roles to All Users; on all pages.

UPDATE mp_Pages

SET AuthorizedRoles = "All Users;"

If you do that then you should rebuild the search index afterwards.

Hope it helps,

Joe

10/13/2009 2:39:02 AM
locutusdiborg
Gravatar
Total Posts 7
View Posts

Re: sub-nodes and contents access authorization

Thank you for the answer.

Is there a way to execute the query from mojoportal directly or I have to create a page.asp with the code in it? ( i don't know if I will have direct access to the database to execute the query from a database control panel )

Thank you again.

10/17/2009 6:56:02 AM
locutusdiborg
Gravatar
Total Posts 7
View Posts

Re: sub-nodes and contents access authorization

Using Microsoft SQL manager 2005 I've managed to execute the query and doing a

select AuthorizedRoles from mp_tables

Return that all roles are updated.

But the site show me that the roles are unchanged. They are all Admins. Its a problem of the serer or mojoportal?

Thankyou.

10/17/2009 8:39:12 AM
locutusdiborg
Gravatar
Total Posts 7
View Posts

Re: sub-nodes and contents access authorization

Solved!

The query has to be executed also on



UPDATE mp_Modules

SET ViewRoles = 'All Users;'

 

To set the permission on the modules!

Thankyou again!

You must sign in to post in the forums. This thread is closed to new posts.