Direction on Access Level / Security Privileges
Posted: Tue May 26, 2009 9:43 am
I have a situation where I need to show/hide certain records based on who logs in. Conceptually, I planned on creating a user table and validating their access with session variables based on their area.
For Example:
User Table:
Username | Password | Area
testa | ******* | 21
Product Data Table:
Product Name | Price | Area
Rag | 1.00 | 21
Tires | 100.00 | 22, 23
So testa user would only be able to see the 'Rag' product and would not be able to see the 'Tires' product.
Before I start heading down the wrong path, I wanted to see if anybody had any other ideas that might be more efficient. Any helpful advice would be appreciated.
For Example:
User Table:
Username | Password | Area
testa | ******* | 21
Product Data Table:
Product Name | Price | Area
Rag | 1.00 | 21
Tires | 100.00 | 22, 23
So testa user would only be able to see the 'Rag' product and would not be able to see the 'Tires' product.
Before I start heading down the wrong path, I wanted to see if anybody had any other ideas that might be more efficient. Any helpful advice would be appreciated.