asked on

access list table

Hi,

one table called user master.

columns are:
ID
username
password

how do we normally design a access list table for web base application?

there will be 3 type of user:
stardard
super
admin

Please kindly assist in designing the access list table (we are using asp.net to build the application)

Thanks.

SOLUTION

Saqib Khan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

EdwardPeter

ASKER

adilkhan,

are we going to have 4 columns on the access list table?

how are we going to use it to determine which access right ?

Thanks.

Saqib Khan

Sorry for confusion, on Access Level Table only 2 Columns,

UID
Level

in Level you will specify what level it is, standars, super or admin.

ASKER CERTIFIED SOLUTION

obahat

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

EdwardPeter

ASKER

obahat,

UserPropertyVector
0 for standard
1 for super
2 for admin
...we can add additional for future access list correct? or i didn't get the approach?

i'm kinda lost on the bit# and what is & 1 >0 ?

Thanks.

EdwardPeter

ASKER

obahat,

basically the access list will be used to identify which type of user inorder to know which hyperlink to enable on the web application. please include the logic for future access list level,

i.e.
semi-admin

Thanks.

Saqib Khan

obahat approach is also great.

just add an column with datatype BIT and assign values to it

if 0 Then Regular
1 then standard
2 then Admin

so in web Aspp

Select Level from user_Table where UID = xxx

so read the Level value and enable/disable it accordingly.