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.