In this chapter, we have taken a look at the different aspects of the authorization concept in SAP HANA. We examined the different authorization levels available in the system, from SQL privileges, analytic privileges, system privileges, and package privileges. We saw how to add these different authorization concepts to a role, a reusable group of authorizations.

We went on to create a new user in our SAP HANA system, examining the different types of authentications available, and the assignment of roles to users.

Finally, we logged into the Studio with our new user account, and found out the first-hand effect our authorizations had on what the user could see and do.

In the next chapter, we will be working with hierarchical data, seeing what hierarchies can bring to our reporting applications, and how to make the best use of them.