Posted by J Mox on 09/28/19 11:29

"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?

[Back to original message]