Because functions are
associated with a database, the functions inherit the access rights
of that database. It might be useful to create a separate shared database
for the SAS scoring functions or the SAS_PUT( ) function so
that access rights can be customized as needed.
You must grant the following
permissions to any user who runs the scoring or format publishing
macros:
CREATE FUNCTION ON database TO userid |
DROP FUNCTION ON database TO userid |
EXECUTE FUNCTION ON database TO userid |
ALTER FUNCTION ON database TO userid |
If you use the SAS Embedded
Process to run your scoring model, you must grant the following permissions:
SELECT, CREATE TABLE, INSERT ON database TO userid |
EXECUTE PROCEDURE ON SAS_SYSFNLIB TO userid |
EXECUTE FUNCTION ON SAS_SYSFNLIB TO userid |
EXECUTE FUNCTION ON SYSLIB.MonitorVirtualConfig TO userid |
Note: If
you plan to use SAS Model Manager with the SAS Scoring Accelerator
for in-database scoring, additional permissions are required.
For more information,
see Configuring SAS Model Manager.