Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Rule table: Administrator or Regular User HELP!

Author  Topic 

lacrimasienna
Starting Member

2 Posts

Posted - 2011-05-24 : 16:21:02
When I make a table where would be Rule for User(for example when user login to some page there would be an option to choose whether that user is an Administrator or a Regular User), which columns I need? I thougt about putting a column Rule type char(1) and if it's value is 'A' then user is Administrator, when it's value is 'R' then user is Regular user. And RuleID. Is that make any sense???? And I will make a rellationship between table User that contains info about users and the Rule table.
Thanks!
   

- Advertisement -