Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Users, Roles and Privileges- Best Practice?

443593Feb 12 2008 — edited Feb 17 2008
I am currently working on the design of a new application. This application will have the following oracle tables to manage users, roles and privileges;

user has one to many roles
e.g. user1 is a clerk and a supervisor
a role has one to many privileges
e.g. a clerk can create and query records, a supervisor can delete records

If I were to use hibernate 3.0 as the persistence layer across the top of my oracle database, what would be the best way to;

a) develop the login functionality
b) manage the user's roles and privileges to enable/disable appropriate functionality within the application, given that the user will have the ability to change both a users roles, and a roles privileges within the application?

Thanks in advance for your thoughts/advice

David
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2008
Added on Feb 12 2008
4 comments
1,584 views