Krishna Reddy

Analytic privileges control access to SAP HANA data models.  Analytic privileges are used to  grant different users access to different portions of data in the same view  depending on their business role. It allows us to maintain  row-level access .  SQL privileges implement authorization at object level only. Users either have access to an object, such as a table, view or procedure, or they do not.  While this is often sufficient, there are cases when access to data in an object depends on certain values or combinations of values. Analytic privileges are used in the SAP HANA database to provide such fine-grained control of which data individual users can see within the same view.  Analytic privileges are intended to control read-only access to SAP HANA information models (attribute views, analytic views, calculation views The attribute restriction of an analytic privilege specifies the value range that the user is permitted to access using value filters. In additio