When you access a SAS Federation Server definer’s rights view that points to a metadata-bound library, you might see the following error:

The following information shows how to re-create the problem:

1. Define a metadata-bound library in the SAS metadata.
2. Point the SAS Federation Server schema to the metadata-bound library. Full access is granted to the SAS power user.
3. The SAS power user creates and owns a second SAS Federation Server schema, containing definer views on each table in the first schema. Grant Select and Execute access on the schema to the SAS demo user.

Now, the SAS power user can successfully access both tables and views, but the SAS demo user cannot access either tables or views. It is by design that this user cannot read the tables through the SAS Federation Server. However, it would be expected that the definer-based view should use the SAS power user credentials to access the underlying table. This procedure works as expected for a non-metadata bound library.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Federation Server	Microsoft® Windows® for x64	4.2	4.2	9.4 TS1M5	9.4 TS1M6
		Microsoft Windows 8 Enterprise x64	4.2	4.2	9.4 TS1M5	9.4 TS1M6
		Microsoft Windows 8 Pro x64	4.2	4.2	9.4 TS1M5	9.4 TS1M6
		Microsoft Windows 8.1 Enterprise x64	4.2	4.2	9.4 TS1M5	9.4 TS1M6
		Microsoft Windows 8.1 Pro x64	4.2	4.2	9.4 TS1M5	9.4 TS1M6
		Microsoft Windows Server 2008 R2	4.2		9.4 TS1M5
		Microsoft Windows Server 2008 for x64	4.2		9.4 TS1M5
		Microsoft Windows Server 2012 Datacenter	4.2	4.2	9.4 TS1M5	9.4 TS1M6
		Microsoft Windows Server 2012 R2 Std	4.2	4.2	9.4 TS1M5	9.4 TS1M6
		Microsoft Windows Server 2012 Std	4.2	4.2	9.4 TS1M5	9.4 TS1M6
		Microsoft Windows Server 2016	4.2	4.2	9.4 TS1M5	9.4 TS1M6
		64-bit Enabled AIX	4.2	4.2	9.4 TS1M5	9.4 TS1M6
		64-bit Enabled Solaris	4.2	4.2	9.4 TS1M5	9.4 TS1M6
		HP-UX IPF	4.2	4.2	9.4 TS1M5	9.4 TS1M6
		Linux for x64	4.2	4.2	9.4 TS1M5	9.4 TS1M6
		Solaris for x64	4.2	4.2	9.4 TS1M5	9.4 TS1M6

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

A fix for this issue for SAS Federation Server 4.2 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/Y46.html#63612

---

When you access a SAS® Federation Server definer’s rights view that points to a metadata-bound library, you encounter the following error: "ERROR: CLI error trying to establish connection: Unable to establish connection : DSN 'BASE' not found or user not authorized."

Type:	Problem Note
Priority:	high

Date Modified:	2019-02-19 13:22:23
Date Created:	2019-02-05 11:24:39