13 Security

Techniques You’ll Master

• Know when to use SAP HANA security
• Understand how users, roles, and privileges work together
• Know how to create new users and roles
• Learn the various types of privileges
• Explain analytic privileges

In this chapter, we’ll discuss how to implement security on the information models you’ve built. Security is frequently a specialist area, with people dedicated to looking after system security and user administration.

We will not go into all the details of SAP HANA security in this chapter, but we’ll give you a good overview to help you with most of the scenarios you will encounter in your day-to-day information modeling work and those that are covered on the exam.

Real-World Scenario

You get an error message in SAP HANA indicating that you do not have sufficient privileges to do a certain task. In cases like these, you will need to know how to resolve this kind of error message. For this situation, the answer is simply granting a right to a special user. In some cases, you may need to build special roles and privileges.

In other cases, you may be asked by the project manager to assist with setting up the security on the information models. Because you built these information models in SAP HANA, you will have a good idea of which users should have certain privileges.

Objectives of This Portion of the Test

The purpose of this portion of the SAP HANA certification exam is to test your knowledge of SAP HANA security.

The certification exam expects you to have a good understanding of the following topics:

• When to use SAP HANA security, and when to use application security
• How users, roles, and privileges work together
• Understanding system users and how to create new users
• Building a new role
• Assigning the various types of privileges to a role
• Working with analytic privileges
• Migrating old analytic privileges in SAP HANA SPS 11

[»] Note

This portion contributes up to 5% of the total certification exam score.