SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
 Apps
X
HANA App
>>>
Hadoop App
>>>
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics
Topic Index
+
-
SAP HANA Modeling
+
-
Spatial Processing
+
-
Predictive Analysis

Installation and Roles required for HANA PAL

In previous article HANA Predictive Analysis Library (PAL), we learnt basic features and functionalities of AFL and PAL.
In this article we will explain installation and roles required to work with PAL.

Prerequisites to use PAL

To use the PAL functions, Application Function Library (AFL) component must be installed in your HANA system. For information on how to install or update AFL, see "Installing or Updating SAP HANA Components" in SAP HANA Server Installation and Update Guide.

Checking PAL Installation

To confirm that the PAL functions were installed successfully, you can check the following three public views:
  • SYS.AFL_AREAS
  • SYS.AFL_PACKAGES
  • SYS.AFL_FUNCTIONS
These views are granted to the PUBLIC role and can be accessed by anyone.

To check the views, run the following SQL statements:
  • SELECT * FROM "SYS"."AFL_AREAS" WHERE AREA_NAME = 'AFLPAL';
  • SELECT * FROM "SYS"."AFL_PACKAGES" WHERE AREA_NAME = 'AFLPAL';
  • SELECT * FROM "SYS"."AFL_FUNCTIONS" WHERE AREA_NAME = 'AFLPAL';

If PAL is installed, you would get output as below.
installation and roles required for PAL

and..
installation and roles required for PAL
Note that the 3rd query returns all the available PAL functions.

Roles required for working with PAL

For each AFL area, there are two roles. You must be assigned one of the roles to execute the functions in the library.
The roles for the PAL library are automatically created when the Application Function Library (AFL) is installed.

The role names are:
  • AFL__SYS_AFL_AFLPAL_EXECUTE
  • AFL__SYS_AFL_AFLPAL_EXECUTE_WITH_GRANT_OPTION

Note: There are 2 underscores between AFL and SYS.
installation and roles required for PAL
To generate or drop PAL procedures, you also need the following role, which is created when SAP HANA is installed:
  • AFLPM_CREATOR_ERASER_EXECUTE

Note: Once the above roles are automatically created, they cannot be dropped. In other words, even when an area with all its objects is dropped and re-created during system startup, the user still keeps these roles.


Support us by sharing this article.



Explore More
Close X
Close X

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy