Aster Permissions

The person who installs the in-database deployment package binary files in Aster needs root privileges for the queen node. This permission is most likely, but not necessarily, needed by the Aster system administrator.
For Aster 6.10 or later, the following schema permissions are needed by the person who runs the scoring and format publishing macros, because all functions and files can be published to a specific schema.
USAGE permission
GRANT USAGE ON SCHEMA yourschemaname TO youruserid;
INSTALL FILE permission
GRANT INSTALL FILE ON SCHEMA yourschemaname TO youruserid;
CREATE permission
GRANT CREATE ON SCHEMA yourschemaname TO youruserid;
EXECUTE permission
GRANT EXECUTE ON FUNCTION PUBLIC.SAS_SCORE TO youruserid;
GRANT EXECUTE ON FUNCTION PUBLIC.SAS_PUT TO youruserid;
GRANT EXECUTE ON FUNCTION PUBLIC.SAS_ROW TO youruserid;
GRANT EXECUTE ON FUNCTION PUBLIC.SAS_PARTITION TO youruserid;
Last updated: February 9, 2017