Building a set of users and roles allows you to manage permissions on a database. Another aspect of database security and management is to limit the resources an individual user can use.
For example, you may want to prevent a single connection from taking too much available memory or CPU resources, and slowing down other database users.