Hello,
I do not know if I post in the right place or not.
So here I am: as the title suggests I have a problem in the management of authorizations.
Here is the solution I have proposed but it does not satisfy everyone and that requires me to dig deeper, but I am stuck too.
I proposed a panel module that contains various modules of the application (example: membership management, statistics etc..), A table function that may be a page, a menu or a submenu or more. Until then, I do unanimously but then when I suggested a table in operations which will make the operations possible on the functions offered, which are themselves part of a module.
As for the user, because when we talk about authorization we understand user, I have a table and a user and profile table as I think that managing access profile that is optimum for each user.
The problem is that I made the remark that if I have a operation table and that the relationship between operation and profile is as follows: a profile can perform such operations, and they say I make a dual setting because each time a user wants to access this operation we will be obliged to return each time to the audit.
I proposed to solve this problem of double parameters to automatically generate a menu, this can not satisfy everyone since there are already people who are beginning to develop because we shared the work module. And the menu has been created so that they can develop their module while I dig in order to improve this part.
I do not know how to solve this problem if you can see it differently, please advise me.
If you have any questions, feel free to ask me and I await your comments irrespective of their nature. I'm running out of solution and a small indication or idea can put on a runway.
In fact I work with Oracle10g.
Thank you!

This seems more of a conceptual design question, so I'm going to move this to Software Development.