“I have had dreams, and I have had nightmares. I overcame my nightmares because of my dreams”
Roles simplify database administration by assigning access rights to tables and other objects, and then groups of people with similar job functions (or roles) can access these objects.
It is as simple as creating different roles for different job functions and responsibilities, and then granting specific privileges (access rights) on database objects to these roles, then granting a role or roles to users who share the same privileges.
Imagine a thousand users accessing certain databases, tables, views, macros ...