Posted by Jerry Stuckle on 09/28/06 11:29

J Mox wrote:
> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
> news:wNKdnTqy45p3KMzeRVn-ug@comcast.com...
>
>>J Mox wrote:
>>
>>>Hi, I am creating a user name system in which each user is assigned 100 different types of
>>>permissions. Is it better to create a table with one row for each user and 101 columns (1 for
>>>userid and 100 for permission values) or 3 columns (1 for userid, 1 for permission id, one for
>>>permission value) and then 100 rows for each user or something else?
>>
>>Two tables. First one has userid and password. Second one has userid and a permission value.
>>
>
>
> Right but in the 2nd table, is it better to have 3 columns and 100 rows for each user or 101 columns
> and one row for each user?
>
>

Ok, I misread the question. Three columns. Userid, permission code and
permission value.

101 columns is inflexible. How much code would you need to change if
you had to add another permission code?

And you probably won't have 100 permission codes for every person, will you?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]