Data access recommendations for linked tables
- Last UpdatedFeb 28, 2025
- 1 minute read
- PI System
- PI Server 2024 R2
- PI Server
Observe the following guidelines for linked tables:
-
If access to linked tables is not needed, disable it altogether.
-
Do not grant the PI AF Application Service account administrative privileges on the PI AF server or SQL Server when running with non-impersonated queries.
-
You must have administrative privileges on the PI AF server to configure an external table that runs non-impersonated queries.