BookmarkSubscribeRSS Feed
Manoj07k
Obsidian | Level 7

Guys , I'm trying to alter ACL of SPDS tables but PROC SPDO is not working on SAS EG and Studio.

 

The code doesn't give any error and no output as well. But, the same works well in server with sas -nodms.

 

SPD(LAX) 5.4 HF(3)

SAS 9.4 M6 

Linux

 

Thanks,

Manoj

7 REPLIES 7
Manoj07k
Obsidian | Level 7

<
LIBNAME &lib sasspds "&lib" HOST='localhost' Serv="5457" USER="&uid" PASSWORD="&psw" ACLSPECIAL=yes;
PROC SPDO LIB=&lib.;
SET ACLUSER spdsrvp;
LIST ACL _ALL_;
run;

At Server :

11?
NOTE: This is a SPD 5.4 (HF3) Engine
executing SAS (r) 9.4 (TS1M6) on the Linux platform.
NOTE: User spdsrvp(ACL Group ) connected to SPD(LAX) 5.4 HF(3) server at
10.5.134.44.
NOTE: Libref VNX_MIG1 was successfully assigned as follows:
Engine: SASSPDS
Physical Name: :20546/XXXXXXX/VNX_MIG1/

12?
NOTE: Enter "?;" to get info on all the SPDO commands.
Enter "SPDSMAC;" to get list and setting of all SPD macros.

13?
NOTE: Acluser has been set to SPDSRVP.

14?

The SAS System 1
Thursday, June 10, 2021 10:07:00 AM

ACL Info for *.DATA

Owner = SPDSRVP
Group =
Default Access (R,W,A,C) = (N,N,N,N)
Group Access (R,W,A,C) = (N,N,N,N)
User = AAAA, Access (R,W,A,C) = (Y,Y,Y,Y)
User = MMMMM, Access (R,W,A,C) = (Y,Y,Y,N)
User = FFFFF, Access (R,W,A,C) = (Y,Y,Y,N)
User = YYYY, Access (R,W,A,C) = (Y,Y,Y,N)
User = XXXX, Access (R,W,A,C) = (Y,Y,Y,N)


At SAS Stuido:

82 LIBNAME &lib sasspds "&lib" HOST='localhost' Serv="5457" USER="&uid" PASSWORD="&psw" ACLSPECIAL=yes;
NOTE: User spdsrvp(ACL Group ) connected to SPD(LAX) 5.4 HF(3) server at 10.5.134.46.
NOTE: Libref VNX_MIG1 was successfully assigned as follows:
Engine: SASSPDS
Physical Name: :6071/XXXXXXXX/VNX_MIG1/
83 PROC SPDO LIB=&lib.;
NOTE: Enter "?;" to get info on all the SPDO commands.
Enter "SPDSMAC;" to get list and setting of all SPD macros.
84 SET ACLUSER spdsrvp;
NOTE: Acluser has been set to SPDSRVP.
85 LIST ACL _ALL_;
86 run;

87
>

LinusH
Tourmaline | Level 20

Perhaps you are using different config files.

Check what values you have for the MSG and PATH options when running EG/Studio, to verify that they include paths to your SPDS client.

Also check the spdsnsrv and spdsserv logs.

Data never sleeps
Manoj07k
Obsidian | Level 7
Hi , Just checked the MSG and PATH it was same at server and in Studio :

MSGPATH=$SASHOME/grid_binaries/SASFoundation/9.4/misc/tkspddrv
PATH=$SASINSTALL/scripts:$SASHOME/spds_binaries/SASScalablePerformanceDataServer/5.4/bin:/bin:$SASHOME/grid_binaries/Secure/sasexe:$SASROOT/pm/10.2/bin:$SASROOT/pm/10.2/linux2.6-glibc2.3-x86_64/bin:$SASROOT/lsf/10.1/linux2.6-glibc2.3-x86_64/etc:$SASROOT/lsf/10.1/linux2.6-glibc2.3-x86_64/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/bin




DavidHD
SAS Employee

@Manoj07k I believe that in the libname statement you need aclspecial=yes and of course the user that you use to connect to the lib needs to be the same. When you connect using EG these might not be the same as on the server when you have pre-assigned libs.

 

Hope this helps,

David

 

Manoj07k
Obsidian | Level 7

Thanks David.

I do use aclspecial=yes in libname statement. Please find the logs of server (nodms) and SAS Stuido.
Code:

LIBNAME &lib sasspds "&lib" HOST='localhost' Serv="5457" USER="&uid" PASSWORD="&psw" ACLSPECIAL=yes;
PROC SPDO LIB=&lib.;
SET ACLUSER spdsrvp;
LIST ACL _ALL_;
run;

At Server :

11?
NOTE: This is a SPD 5.4 (HF3) Engine
executing SAS (r) 9.4 (TS1M6) on the Linux platform.
NOTE: User spdsrvp(ACL Group ) connected to SPD(LAX) 5.4 HF(3) server at
10.5.134.44.
NOTE: Libref VNX_MIG1 was successfully assigned as follows:
Engine: SASSPDS
Physical Name: :20546/XXXXXXX/VNX_MIG1/

12?
NOTE: Enter "?;" to get info on all the SPDO commands.
Enter "SPDSMAC;" to get list and setting of all SPD macros.

13?
NOTE: Acluser has been set to SPDSRVP.

14?

The SAS System 1
Thursday, June 10, 2021 10:07:00 AM

ACL Info for *.DATA

Owner = SPDSRVP
Group =
Default Access (R,W,A,C) = (N,N,N,N)
Group Access (R,W,A,C) = (N,N,N,N)
User = AAAA, Access (R,W,A,C) = (Y,Y,Y,Y)
User = MMMMM, Access (R,W,A,C) = (Y,Y,Y,N)
User = FFFFF, Access (R,W,A,C) = (Y,Y,Y,N)
User = YYYY, Access (R,W,A,C) = (Y,Y,Y,N)
User = XXXX, Access (R,W,A,C) = (Y,Y,Y,N)


At SAS Stuido:

82 LIBNAME &lib sasspds "&lib" HOST='localhost' Serv="5457" USER="&uid" PASSWORD="&psw" ACLSPECIAL=yes;
NOTE: User spdsrvp(ACL Group ) connected to SPD(LAX) 5.4 HF(3) server at 10.5.134.46.
NOTE: Libref VNX_MIG1 was successfully assigned as follows:
Engine: SASSPDS
Physical Name: :6071/XXXXXXXX/VNX_MIG1/
83 PROC SPDO LIB=&lib.;
NOTE: Enter "?;" to get info on all the SPDO commands.
Enter "SPDSMAC;" to get list and setting of all SPD macros.
84 SET ACLUSER spdsrvp;
NOTE: Acluser has been set to SPDSRVP.
85 LIST ACL _ALL_;
86 run;

87

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 7 replies
  • 657 views
  • 7 likes
  • 5 in conversation