Joe,

Is there a global setting that allows you to set view permissions for a whole site?

As opposed to checking this setting on every page?

Thanks,
John

I wasn't sure whether to mention a direct database update as it could be dangerous.

After backing up my database I did a quick test on a small demo site that appeared to work for me.

First I looked at the AuthorizedRoles field of dbo.mp_Pages to see what I needed to change from (I did this via WebMatrix, but could have used the 'Select top 1000 rows' option in MS SQL SMS)

I tried 2 ways, both using MS SQL Server Management Studio. The simplest was to open the database, right click on dbo.mp_Pages, select edit top 200 rows and then manually change the entries in field AuthorizedRoles. Its easy to slip in a typo but at least you're in control of the changes.

The second was to create the following SQL queries

SELECT *
FROM dbo.mp_Pages
WHERE AuthorizedRoles = 'All Users;'
GO

to check which rows would be affected from my chosen where statement and

SELECT *
FROM dbo.mp_Pages
WHERE AuthorizedRoles <> 'All Users;'

GO

to check rows that would not be affected, then

UPDATE dbo.mp_Pages
SET AuthorizedRoles = 'Authorized Users;'
WHERE AuthorizedRoles = 'All Users;'
GO

to make the changes

My demo site is very small so may not be very representative.

I couldn't say definitively that there would be no side-effects from manipulating the database in this way, or that this is a good way to go, just that it appeared to work for me. And I'd definitely take a backup first - its a potentially dangerous thing to fiddle with the database.

Using the MojoPortal interface may be more long-winded, but its the safest of all options.

Spike