There are two sets of
permissions involved with the SAS Accelerator Publishing Agent software.
The first set of permissions
is needed to publish the SAS 9.2 Formats Library for Netezza and the
SAS_COMPILEUDF,
SAS_DIRECTORYUDF, and
SAS_HEXTOTEXTUDF functions. These permissions must be granted before
the
%INDNZ_PUBLISH_JAZLIB
and
%INDNZ_PUBLISH_COMPILEUDF macros are run. Without these permissions, running these macros
fails.
The following table
summarizes the permissions that are needed by the person who publishes
the formats library and the functions.
|
|
Authority Required to
Grant Permission
|
|
CREATE LIBRARY permission
to run the %INDNZ_PUBLISH_JAZLIB macro that publishes the SAS 9.2 Formats Library ( sas_jazlib object)
|
System Administrator
or Database Administrator
Note: If you have SYSADM or DBADM
authority, then you have these permissions. Otherwise, contact your
database administrator to obtain these permissions.
|
GRANT CREATE LIBRARY
TO fmtlibpublisherid |
CREATE FUNCTION permission
to run the %INDNZ_PUBLISH_COMPILEUDF macro that publishes the SAS_COMPILEUDF, SAS_DIRECTORYUDF, and the SAS_HEXTOTEXTUDF functions
|
GRANT CREATE FUNCTION TO
compileudfpublisherid |
The second set of permissions
is needed by the person who runs the scoring publishing macro,
%INDNZ_PUBLISH_MODEL, or the format
publishing macro,
%INDNZ_PUBLISH_FORMATS. The person who runs these macros is not necessarily
the same person who runs the %INDNZ_PUBLISH_JAZLIB and %INDNZ_PUBLISH_COMPILEUDF
macros. These permissions are most likely needed by the scoring model
or format publishing developer. Without these permissions, the publishing
of the scoring model functions and the SAS_PUT()
function and formats fails.
Note: Permissions must be granted
for every scoring model and format publisher and for each database
that the scoring model and format publishing uses. Therefore, you
might need to grant the above permissions multiple times. After the
Netezza permissions are set appropriately, the scoring model or format
publishing macros can be run.
Note: When permissions are granted
to specific functions, the correct signature, including the sizes
for numeric and string data types, must be specified.
The following table
summarizes the permissions that are needed by the person who runs
the scoring or format publishing macro.
|
|
Authority Required to
Grant Permission
|
|
EXECUTE permission
for the SAS 9.2 Formats Library
|
System Administrator
or Database Administrator
Note: If you have SYSADM or DBADM
authority, then you have these permissions. Otherwise, contact your
database administrator to obtain these permissions.
|
GRANT EXECUTE ON SAS_JAZLIB TO
scoringorfmtpublisherid |
EXECUTE permission for
the SAS_COMPILEUDF function
|
GRANT EXECUTE ON SAS_COMPILEUDF
TO scoringorfmtpublisherid |
EXECUTE permission for
the SAS_DIRECTORYUDF function
|
GRANT EXECUTE ON SAS_DIRECTORYUDF
TO scoringorfmtpublisherid |
EXECUTE permission for
the SAS_HEXTOTEXTUDF function
|
GRANT EXECUTE ON
SAS_HEXTOTEXTUDF
TO scoringorfmtpublisherid |
CREATE FUNCTION, CREATE
TABLE, CREATE TEMP TABLE, and CREATE EXTERNAL TABLE permissions to
run the scoring and format publishing macros
|
GRANT CREATE FUNCTION TO
scoringorfmtpublisherid
GRANT CREATE TABLE TO
scoringorfmtpublisherid
GRANT CREATE TEMP TABLE TO
scoringorfmtpublisherid
GRANT CREATE EXTERNAL TABLE TO
scoringorfmtpublisherid |