|
Posted by Jerry Stuckle on 09/28/46 11:29
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.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|