Using an Analytic Privilege for specific time in SAP HANA

Yes, when an Analytic Privilege is defined you have an option of using it for a specific time period. You have an option of defining Privilege validity where you can pass validity details.

You can also opt for SQL Editor or Dynamic where you can pass different validity conditions. When you use SQL option you can pass a SQL query and it will be set as per SQL query

For Dynamic option, you can pass Stored Procedure to define validity.

Updated on: 12-Mar-2020


Kickstart Your Career

Get certified by completing the course

Get Started