Security settings for linked tables
- Last UpdatedFeb 28, 2025
- 2 minute read
- PI System
- PI Server 2018
- PI Server
You use the PI AF Diagnostics utility (afdiag located in the %PIHOME64%\AF folder) to enable or disable support for external PI AF tables. Since the utility makes a direct connection with the associated SQL Server database, the SQL Server sysadmin or db_AFadmin role is required.
Use the PI AF Diagnostics utility to adjust security settings for external tables.
|
Task |
Command |
Default Setting |
|---|---|---|
|
Enable support for external PI AF tables |
afdiag /DT |
enabled |
|
Disable support for external PI AF tables |
afdiag /DT- |
|
|
Enable support for external PI AF tables for non-impersonated users |
afdiag /DTImp |
disabled |
|
Disable support for external PI AF tables for non-impersonated users |
afdiag /DTImp- |
|
|
Change security settings for a specific PI AF table |
In the Library browser, right-click on the table and click Security. |
By default, table configuration requires administrative privileges on the PI AF server. |
|
Change security settings for all tables |
In the Library browser, right-click on Tables and click Security. |
By default, table configuration requires administrative privileges on the PI AF server. |
Note: You do not have to enable support for external PI AF tables for non-impersonated users. You can include a user ID and password as part of the connection string in a PI AF table connection and check it in, regardless of whether support for external PI AF tables for non-impersonated users is enabled. The defined PI AF table connection can be used within a PI AF table definition. This means that if a SQL Server Login has permission to access the data referenced in the connection string, a PI AF table linked to that PI AF table connection can retrieve the external data.