Skip to main content

A number of wishes have been submitted in TCP concerning adding rights to an objects.

They indicate that when rights are granted to an object, they must also be granted to its childs. Same goes for revoking these rights. I was able to extract the following situations:

  • Rights for a table should pass on to its columns
  • Rights for a task should pass on to its task parameters
  • Rights for a report should pass on to its report parameters
  • Rights for a menu should pass on to its menu items
  • Rights for a process flow should pass on to its process actions

A number of questions about this wish:

  • What if a new column / task parameter / report parameter / menu item is added after setting up the rights?
  • If you give a table rights because you need a column look-up, you now only get the display. Should this change?
  • Am I still missing situations that should also be taken into account for this wish?
    • Personally, I think that when adding a table task, for example, it is going too far to give rights to both the table with its columns and the task with its parameters.

@Jeffrey Tolboom@Roland van Aggele@Jaap van Beusekom@Gijs@Remco@Arjan Sollie@Jasper

Since you have reported a wish concerning this topic, I would certainly like to hear your opinion. Other opinions are also of course appreciated.

I’m wondering - what was the reason for the wish, I only see a solution - but not the problem that has to be solved.

 

  • What if a new column / task parameter / report parameter is added after setting up the rights?

 

Why not follow something like filesystems do - explicit permissions overrule inheritance (as in no explicit permission equals the parent permission) 

The question that remains in this is - who may be a parent? Can a (table)task be the parent of a table?

 

 


Updated idea status NewOpen

I think new columns/task parameters should behave based on a setting of the parent. So base this on a property like 'auto_assign_new_column’. I think the default value when granting a complete table should be ‘yes’. When you are being granular at first setting this up, it should be ‘no'.


The following idea has been merged into this idea:

All the votes have been transferred into this idea.
  • What if a new column / task parameter / report parameter is added after setting up the rights?
    • For this question I'm behind the idea that Robert-Jan presented
  • If you give a table rights because you need a column look-up, you now only get the display. Should this change?
    • For this scenario I'd say having the display is enough when the only reason for the rights is to view the column look-up
  • I think that when adding a table task, for example, it is going too far to give rights to both the table with its columns and the task with its parameters.
    • Personally I wouldn’t go that far either with granting rights to the parent of the given object. What I would like though is when granting rights from the parent, in this case the table, that when granting table task rights the task parameters are also included

It would be nice if the rights structure in TSF is visible everywhere within the context of objects (tables, tasks, reports, columns, parameters, etc).

Just like translations are available everywhere.


In regards to setting up the rights, I indeed would prefer when I set through the tasks that Tasks, Reports or Tabdetails, Tabtasks and Tabreports should also be set to granted, all of these tasks, report and tables their parameters/columns should also be made granted and available.

Because currently the SF will allow you to set these objects to granted and available through the task and in the table, task and report list the will show up has read only. However since no column or parameters has been assigned the rights have not been set at all. So this is giving a false pretension.

So if be default these parameters and columns are also set to granted (editable) if you enable these tables, tasks and reports through this tasks, that will save a lot of headaches.

In regards to managing rights on exists roles, I agree with RJ his idea. You should be able to mark tables, tasks, reports, etc.. as auto assign new rights. This auto assign new rights should also be included as a parameter in the task to assign rights. Otherwise after setting rights you would still have to manually walk through all objects again to set this checkbox.


Updated idea status OpenOn the backlog
The following idea has been merged into this idea:

All the votes have been transferred into this idea.

I like Ricky’s suggestion in that columns always inherit the rights of the table unless explicitly defined otherwise. This is quite similar to column rights in SF. A table can have an editable column in its data model. This column is then also editable in the GUI definition under subjects unless it’s overruled there in its list, form or both. I think I would like this style best in rights as well.


The following idea has been merged into this idea:

All the votes have been transferred into this idea.

The following idea has been merged into this idea:

All the votes have been transferred into this idea.

The model rights screen currently provides partial insight into which roles have permissions on a specific object. The new objects screen provides insight into which new objects have been added. By revising the current model rights, we aim to make the combination of the two more insightful and make it easier to assign rights to new objects.

Additionally, we want to offer an alternative to the 'Assign rights' task, where we currently display the affected objects that can collectively be set to true or false. By introducing enrichments, developers will have more flexibility to choose which actions to execute.


On the backlogPlanned

This is planned to be resolved with the Roadmap 2025 H1 efforts.


Hello everyone!

The first part of the changes mentioned in this topic has been implemented in the Software Factory as soon as the current sprint has been completed, which means it will be included in the 2025.1 release. This development concerns the revision of the Model rights screen. The detail tab page New objects that existed within this screen has been removed and has been replaced with its own menu item called New objects. This menu item can be found under Access Control.

This New objects screen will show insights in both the existing as well as the new model objects that have been introduced in the current model version.

By default the screen will be filtered so it only shows the new objects, however when one wants to compare these new objects to the settings of the previously existing objects, the corresponding prefilter can be disabled to show all objects.

Additional visual support for the developer is included through means of status icons and badges, indicating if and how many new objects still need to be verified.

Some examples of what this looks like:
 

Both the table ‘sub_task' and 50% of its columns are unverified. The icon is fully yellow indicating both the parent and possible children are unverified. The badge on columns displays y2], indicating that there are 2 unverified columns.
Only the table sub_task unverified, but its columns 100% verified. The large icon is yellow, indicating that the parent, in this case the table, has not been verified. The small dot on the right bottom side is green, indicating that the children have been verified.
 
In the case of menus the badges are quite helpful. In this case there are 2 menus affected by new objects, when selecting that menu the badges provide the insight that this concerns 2 treeview groups and 1 treeview item within the ‘test’ treeview group.

 

This is the first step towards an easier process of granting rights to an objects and its children.

The follow-up step of including child-rights when granting parent-rights will be included in the follow-up of this development.

 

Hopefully this provides some insight into the new developments regarding this topic and I hope you all look forward to having this in the new version of the Software Factory ! 😊