Permission Needed
|
Authority Required to
Grant Permission
|
Examples
|
---|---|---|
CREATE LIBRARY permission
to run the %INDNZ_PUBLISH_JAZLIB
macro that publishes the SAS 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 |
Permission Needed
|
Authority Required to
Grant Permission
|
Examples
|
---|---|---|
EXECUTE permission
for the SAS 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 format and scoring publishing macros
|
GRANT CREATE FUNCTION TO scoringorfmtpublisherid GRANT CREATE TABLE TO scoringorfmtpublisherid GRANT CREATE TEMP TABLE TO scoringorfmtpublisherid GRANT CREATE EXTERNAL TABLE TO scoringorfmtpublisherid GRANT UNFENCED TO scoringorfmtpublisherid |
/nz/export/ae/utlities/bin/create_inza_db_user.sh user-name database-name /nz/export/ae/utilities/bin/create_inza_db.sh database-name