P_SECAUTH_21 · Question #21
P_SECAUTH_21 Question #21: Real Exam Question with Answer & Explanation
The correct answer is A. Control of read-only access to SQL views D. Complex filtering. These are some of the features that SAP HANA SQL-based analytic privileges offer compared to classic XML-based ones. Analytic privileges are privileges that restrict access to data in analytical views or calculation views based on certain conditions or filters. SAP HANA supports
Question
Options
- AControl of read-only access to SQL views
- BControl of read-only SAP HANA procedures
- CTransportable
- DComplex filtering
Explanation
These are some of the features that SAP HANA SQL-based analytic privileges offer compared to classic XML-based ones. Analytic privileges are privileges that restrict access to data in analytical views or calculation views based on certain conditions or filters. SAP HANA supports two types of analytic privileges: SQL-based and XML-based. SQL-based analytic privileges are defined using SQL statements and stored as database objects. XML-based analytic privileges are defined using XML files and stored as repository objects. SQL-based analytic privileges offer more features and flexibility than XML-based ones, such as control of read-only access to SQL views, which prevents users from modifying data in the views, and complex filtering, which allows users to define multiple filters with different operators and expressions.
Community Discussion
No community discussion yet for this question.