I suggest that TuM familiarizes himself with the logic of Oracle Priviliges and Roles. It might provide a good example for a design for a customized system.