Permissions required when you use SAS® Enterprise Guide® to create a stored process


When using SAS Enterprise Guide to create a Stored Process, the required file access permissions are determined by the execution server that is used for the Stored Process.

If you select the "Logical Stored Process Server" as the "Execution Server" to run your Stored Process, then the "sassrv" user account will be used when running your Stored Process. So, "sassrv" must have file permissions to read and write to the "Source file path" location where the Stored Process SAS code will be saved and "sassrv" must have permissions to execute the SAS code. The file permissions are determined by the operating system.

However, if you select the "Logical Workspace Server" as the "Execution Server" to run your Stored Process, then the Enterprise Guide logon user account must have file permissions to read and write to the "Source file path" location where the Stored Process SAS code will be saved and this user account must also have permissions to execute the code. For example, if you logon to Enterprise Guide using the "sasguest" user account, then "sasguest" must have the appropriate permissions. In addition, all user accounts that use Enterprise Guide to create Stored Processes with the Workspace Server must have the appropriate permissions.

The below error messages will occur if your user account does not have sufficient permissions to write to the "Source file path" location where the Stored Process SAS code is to be saved.

The file could not be copied to the specified location.
 
Unrecognized error:
 
Enterprise Guide encountered an unrecognized error associated with the stored process server or metadata server. The error message returned from the server is provided below:
 
Server error message: Insufficient authorization to access c:\your_path\your_file.sas.
 
Insufficient authorization to access c:\your_path\your_file.sas.
 
at SAS.FilerefClass.OpenTextStream(StreamOpenMode Mode, Int32 MaxLineLength) at SAS.EG.StoredProcesses.Model.RemoteAppStoredProcess. WriteCodeToStoredProcess Server()Unrecognized error:

 

If you are unsure whether a user account has permission to write to a specific directory, logon to your computer using that user account. Once you are logged on, you can either attempt to write to the "Source file path" location or execute your Stored Process as a regular SAS job and check your SAS log for error messages related to permissions.

When using SAS Enterprise Guide to create a Stored Process, if you receive the

"Insufficient authorization to access"
 

error message, the following log files should be helpful.

 

If you receive the "Insufficient authorization to access" error message when using the "Logical Workspace Server" for your "Execution Server" for your Stored Process, then, as a test, try the "Logical Stored Process Server" for your "Execution Server". If you can successfully create the Stored Process file when using the "Logical Stored Process Server", then the "sassrv" user account has appropriate permissions to write to the "Source file path" (while your Enterprise Guide logon user account does not).

If the "sassrv" account does not have permission to access the metadata for the stored process, you may receive the following error message:

"Could not load stored process from metadata"
 

See SAS Note 16429  for information about the required permissions for the metadata folders in which stored processes are created.