Win a copy of Fixing your Scrum this week in the Agile forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Rob Spoor
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Junilu Lacar
  • Tim Cooke
Saloon Keepers:
  • Tim Holloway
  • Piet Souris
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Frits Walraven
  • Himai Minh

JFORUM_ROLES and JFORUM_ROLE_VALUES tables?

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Can you tell me what is being captured in the JFORUM_ROLES and JFORUM_ROLE_VALUES tables? Where is this information used?

Thanks
[originally posted on jforum.net by clc1023]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The short answer is that these are the security tables...

If I remember right, the JFORUM_ROLES maps permissions to groups. Permissions can be "global", e.g. perm_administration, or they can be specific to some other area, e.g. perm_category to see a category or perm_forum to see a forum.

If the permission applies to a sub area. The JFORUM_ROLE_VALUES table gets used to identify the subarea. E.g., the Role_Value field in the record that matches the role_id, gets the id of the category or forum that the permission applies to.
[originally posted on jforum.net by monroe]
 
Willie Smits increased rainfall 25% in three years by planting trees. Tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic