You must have DB2 user
permissions to execute the SAS publishing macros to publish the SAS_PUT( )
and format 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 SAS_PUT( ) and format 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 the SAS_PUT( )
and format functions and for each database that the format publishing
uses. Without these permissions, publishing of the SAS_PUT( )
and format functions 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.