Problem Note 36519: LIBGEN=YES generated librefs not supplying all credentials for SAS® Scalable Performance Data Server
 |  |  |  |  |
If you specify LIBGEN=YES on a SAS® Scalable Performance Data Server LIBNAME statement, and then that libref is generated for PROC SQL, it is only providing the domain name (DBQ) for the generated libref. Because the username and password of the generated libref are not included, it is inheriting this information from the explicit SQL LIBNAME connection.
This causes problems because any tables accessed or created in the generated libref will use the ACLs of the explicit connection userid rather than the userid of the original libref with LIBGEN=YES in effect.
The librefs with LIBGEN=YES in effect for PROC SQL must include the username and password of the original libref to ensure correct behavior. In addition, you should include the server and host. If you do not include the server and the host, they will be inherited from the explicit connection.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SPDS | Scalable Performance Data Server | Microsoft Windows 2000 Professional | 4.4 TSM4 | 4.4 TSM8 | ||
| Microsoft Windows XP Professional | 4.4 TSM4 | 4.4 TSM8 | ||||
| 64-bit Enabled AIX | 4.4 TSM4 | 4.4 TSM8 | ||||
| 64-bit Enabled HP-UX | 4.4 TSM4 | 4.4 TSM8 | ||||
| 64-bit Enabled Solaris | 4.4 TSM4 | 4.4 TSM8 | ||||
| HP-UX IPF | 4.4 TSM4 | 4.4 TSM8 | ||||
| Solaris for x64 | 4.4 TSM4 | 4.4 TSM8 | ||||
A fix for this issue for SPD Server 4.4 is available at:
http://www.sas.com/techsup/download/hotfix/spds44.html#036519| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2010-03-12 19:04:49 |
| Date Created: | 2009-07-13 14:45:27 |