Need suggestions on implementing categories for roles on permissions setup

Posted this in the MySQL forums, but I think this has to do with CF too.

Here’s the original post,

Anyone done something like this?

I was thinking one possible solution was having a type column in the permissions table and instead of just having a list to find in, having some sort of structure or array…*but, this seems like to over thinking this and it should end up being more elegant.