Thursday, September 22, 2005 8:52 PM
Hi Scott - I tried to post a comment here without logging in (ie as anonymous) and got the following error:
A critical error has occurred.
Cannot insert the value NULL into column 'UserID', table 'smcculloch.dbo.DnnForge_NewsArticles_Comment'; column does not allow nulls. INSERT fails. The statement has been terminated.
Any way, I'll see how it goes now I'm logged in :-)
My message was:
Hi Scott,
I would suggest that you can assign any given role(s) to any given category. eg.
Take the following:
User A , User B, User C
Category 1, Category 2, Category 3
Role_i, Role_ii
User A is in Role_i
User B is in Role_ii
Category 1 has Role_i assigned to it
Category 2 has Role_ii assigned to it
Category 3 has no Roles(ie default to all users)
So, User A can See all Category 1 and 3 articles
User B can see all Category 2 & 3 articles
User C can only see category 3 articles ?
Does that make any sense ?
Cheers,
Ian (
Thursday, September 22, 2005 8:52 PM
Yep - looks like I found a bug :-) works fine now I'm logged in. :-)
Thursday, September 22, 2005 11:30 PM
I was thinking of having permissions for view,submit,approve on each role.
What happens when an article is assigned to 2 or more categories. Must it satisfy the view permissions of both categories or just one?
Friday, September 23, 2005 1:13 AM
I agree with the permissions for view,submit,approve - and as for an article belonging to multiple categories, personally I think that if the user should only be able to see the articles in the category that he/she has rights to - if the article happens to be in 2 categories, then the user would only be able to see the article in the category that they have rights to and not in the other one - after all the permissions are per category, and not per article right ?
Saturday, September 24, 2005 12:18 AM
>What happens when an article is assigned to 2 or more categories.
My 2 cents worth is that if the user has permissions for _either_ category he should be able to view the article.
John Tarbox