In DNN, a super-user or host-user has advanced permissions to do things like 

  1. install extensions and themes
  2. create new portals
  3. access / manage the database

Normal admin users are not allowed to do this, as incorrect handling could break things.