You must have DB2 user
permissions to execute the SAS publishing macros to publish the scoring
functions. Some of these permissions are as follows.
-
EXECUTE user permission for functions
that were published by another user
-
READ user permission to read the
SASUDF_COMPILER_PATH and SASUDF_DB2PATH global variables
-
CREATE_EXTERNAL_ROUTINE user permission
to the database to create functions
-
CREATEIN user permission for the
schema in which the scoring functions are published if a nondefault
schema is used
-
CREATE_NOT_FENCED_ROUTINE user
permission to create UDFs that are not fenced
Permissions must be
granted for each user that needs to publish a scoring function and
for each database that the scoring model publishing uses. Without
these permissions, publishing of the scoring functions will fail.
The person who can grant
the permissions and the order in which permissions are granted is
important. For complete information and examples, see the installation
and configuration instructions in the
SAS In-Database Products: Administrator's Guide.