I can successfully write to the tag using Student01 account from SQL Commander when using PI OLEDB Provider connection.
However, when I try to do similar from MSSQL using a linked server and using current user security context I receive the below error
SELECT * FROM OPENQUERY([PIOLEDB], 'INSERT piarchive..picomp2 (tag, time, value)
VALUES (''SSISPackageTracker'', ''*'', ''test'')')
Msg 7357, Level 16, State 2, Line 9
Cannot process the object "INSERT piarchive..picomp2 (tag, time, value)
VALUES ('SSISPackageTracker', '*', 'test')". The OLE DB provider "PIOLEDB" for linked server "PIOLEDB" indicates that either the object has no columns or the current user does not have permissions on that object.