I would like to delegate access for Adding Users and Assigning Users to different User Groups to non-admin user. However, the right for Creating User Groups and Access permission to tables for User groups will remain with Administrator only.
I use separate table for Users. Hence giving access for Adding Users in this table can be done. But giving access for Assigning Users to different Groups is the area where I am feeling difficulty.
Any idea how to do that, using Dynamic Permission? Why the Three tables that are generated by "Dynamic Permission" are not seen in "Datasource Tables" (only views are visible), like any other table? If those are visibile in Datasource table, then the same functionality can be achieved easily.
Any idea / help to make this happen?
Thannks in advance.