"ERROR: User does not have appropriate authorization level for library xxxx" might occur in SAS® Information Map Studio and SAS® Web Report Studio


Overview

When validating an expression or testing a query in SAS Information Map Studio, or when rendering a report in SAS Web Report Studio, you might see errors that are similar to the following:

Error while submitting SAS code LIBNAME mylib BASE "c:\mydata"; ERROR: User does not have appropriate authorization level for library mylib ERROR: Error in the LIBNAME statement
 
The most likely cause of the error is that the account that is used to launch the pooled workspace server does not have the appropriate operating system permissions on the location referenced in the error message.

Resolution

Typically, sassrv (the login for the SAS General Servers group) is the account that is used to launch the server. To determine which account is used at your site, see How to verify the pooled workspace server launch credentials).

When you know the pooled workspace server launch credentials, give the credentials the necessary operating system permissions to the location referenced in the message. For example, the sample message references a folder named mydata. So, you could explicitly assign permissions on the mydata folder, or you could add the credentials to an operating system group that already has permissions to mydata.

How to verify the pooled workspace server launch credentials

To determine which credentials are being used for the pooled workspace server, perform these steps:

Note: SASApp is the default server context name. Your server context might have a different name.

    1. Log into SAS Management Console with an account that has permission to access the Server Manager plug-in.
    2. Navigate to Server Manager ► SASApp ► SASApp - Logical Pooled Workspace Server ► SASApp - Pooled Workspace Server.
    3. Right-click on SASApp - Pooled Workspace Server and select Properties.
    4. Click the Options tab. The credentials appear in the Multiuser credentials box.

CAUTION: If you decide to change the credentials for the pooled workspace server, then you must restart your object spawner for the change to take effect.

Note: This error can occur in SAS Information Map Studio and SAS Web Report Studio even though you can successfully submit the LIBNAME statement in SAS Enterprise Guide.