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 4.5, no permissions
are needed by the person who runs the scoring or format publishing
macros, because all functions and files are published to the PUBLIC
schema.
For Aster 4.6 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;