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 functions 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 fails.
The
person who can grant the permissions and the order in which permissions
are granted is important.
For more information
about specific permissions, see DB2 Permissions in SAS In-Database Products: Administrator’s Guide.