2 Questions on Privileges in SAP HANA

[Former Member]

Dear All,

Can any one of you please help me in getting the answers for the below 2 questions? Also, can you please explain me the reason why that particular privilege is only applicable?

1. Which privilege can be applied to restrict user for accessing data for specific  years and region?

A. SQL Privilege

B. Analytic Privilege

C. System Privilege

D. Package Privilege

2. Which privilege can be grant to users for department wise .

A. SQL Privilege

B. Analytic Privilege

C. System Privilege

D. Package Privilege

Thanks in advance,

Best Regards,

KV

[rindia · Accepted solution]

Hi Venkata,

Here are the answers:

1. Which privilege can be applied to restrict user for accessing data for specific  years and region?

   B. Analytic Privilege (for specific years and region)

2. Which privilege can be grant to users for department wise .

   B. Analytic Privilege (for specific department)

In both the questions, the user is restricted to see limited amount of data.

Regards

Raj

[Former Member · Accepted solution]

Hello Venkata,

This is implemented at the Analytic Privileges level.

Analytic Privilege:

This restriction is done at the Analytic privileges level where you
can choose the  HANA Analytic/Calc. view ; then it allows you to select the
column on which you need to impose security; here  in your case 'Department'.

This is nothing but implementing security at the row level

User needs to be assigned the Analytical privileges - which defines for
what HANA views he/she has the access and for what data.

SQL privilege : (Releated to the above)

You need to add the below SQL Objects under SQL Privileges

a. _SYS_BI
B. The HANA analytic/calc view(s)
c. REPOSITORY_REST(SYS)

Also System Privilges and Packages Privileges should be assigned to the user

Regards

Ramesh

[Former Member]

Dear Both,

Thanks a lot....

Regards,

Rama