Skip to main content
Open

Roles: assign rights presets

Related products:Software Factory
  • February 16, 2022
  • 1 reply
  • 106 views

Forum|alt.badge.img+6

I would like to able to alter the presets (or add my own presets) to the presets dropdown while assigning rights to an object.
 

I need to set the roles for a lot of tables and they all need the same permissions.
An alternate solution would be manually running the task_role_tab_set_rights but I'm not really comfortable doing that without knowing the implications :)
For now I altered the def_role_tab_set_rights in SSMS to alter which checks are set by each of the 3 presets, fortunately I only needed 3 different presets.

1 reply

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Software Architect
  • February 16, 2022

Hi Alban, that is currently not possible, but I'll change this topic to an Idea to see if others would like this too :grin:


Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Software Architect
  • February 24, 2022
Updated idea statusNewOpen