please help w/role model 1

[CRuser89]

Hello,

I need to create a role-based ER diagram for a new applicaiton we're developing. Basically the diagram should have roles, privileges, permissions, etc of what a user can and cannot see in the application.

I am using SQL Server 2000. Can someone please point me to where I can see a sample role-based access diagram?

Thanks,
Kathy

 

[MikeBronner]

You will need to develop this pretty much on your own based upon the unique requirements of your application. However, most role-based systems have the following tables set up:

users - stores user account info
users_roles - join table so that multiple users can have the same role, and one user can have multiple roles
roles - stores the role(s) that are linked to the user accounts
roles_permissions - join table to facilitate many-to-many joins between roles and permissions
permissions - stores the name of the permission, with an appropriate flag value (this can be true/false most of the time).

To determine what is visible in the app, you then need to write functions that will see if a certain permissions is connected to the current user, and then display, or not, the sensitive information.

I hope this helps you get in the right direction.

Take Care,
Mike

 

[CRuser89]

Thank you Mike for takign the time to explain all this to me. It's very helpful...

Thanks again,
Kathy