Desktop productivity for business analysts and programmers

Authorization Issues (ERROR: Insufficient authorization to access ...)

Reply
New User
Posts: 1

Authorization Issues (ERROR: Insufficient authorization to access ...)

Hello Everyone!

I am a SAS programmer still acclimating to the SAS Enterprise Guide environment. I am having several issues regarding authorizations that I think have the same root cause. I am trying to determine whether the resolution lies in the systems security or a SAS/Management Console.

Issue 1) I am able to create an RTF file and Right Click>Export the file to a public location, but I am not able to write ODS statements that would produce a file in that same location

ods rtf file="\\\psp.rtf";
ERROR: Insufficient authorization to access \\\psp.rtf.

Issue 2) Similarly I am unable to create a library using the LIBNAME statement for folders I know I have access to

libname temp "\\\Temp\";
ERROR: User does not have appropriate authorization level for library TEMP.

Issue 3) I can use the import wizard to read in a raw data .txt file but I am unable to write my own code. That is, SAS has an issue giving me access to the path I state in the INFILE statement. On a side note, I notice that EG generates code referencing a path to a tempory folder on the SAS server INFILE 'C:\Users\...\AppData\Local\Temp\SAS Temporary Files\_TD6316\#LN00380' so SAS must be creating a temporary copy on the SAS server?

In summary, I would say my problem revolves around SAS communicating with the network drives. While many tasks can be done using the GUI, I want the flexibility to write my own code in order to take advantage of macro programming to make the output more dynamic.

Any input would be much appreciated,

Chris
Community Manager
Posts: 2,696

Re: Authorization Issues (ERROR: Insufficient authorization to access ...)

If this is going to a Windows SAS server and you are accessing a network resource (such as file path using UNC notation), you might need to set the server machine to be Trusted for Delegation. That's an Active Directory setting.

http://support.sas.com/documentation/cdl/en/bisecag/61133/HTML/default/viewer.htm#a003181427.htm

Chris
Occasional Contributor
Posts: 10

Re: Authorization Issues (ERROR: Insufficient authorization to access ...)

See the response by Cynthia@SAS at:

Contributor
Posts: 70

Re: Authorization Issues (ERROR: Insufficient authorization to access ...)

Hi All - Is this setting required even if we dont use IWA? I am getting the Access denied error for few files. I am able to access the same files from windows explorer. Files are located on UNC path.

Community Manager
Posts: 2,696

Re: Authorization Issues (ERROR: Insufficient authorization to access ...)

Yes, Trusted for Delegation is still needed, even if not using IWA.  This allows your "auth" to be forwarded to another network resource such as a UNC path or a network printer.  The topic here addresses just IWA, but I believe it applies for any case where your Windows or AD credentials are used to access the server.

Ask a Question
Discussion stats
  • 4 replies
  • 12441 views
  • 0 likes
  • 4 in conversation