Skip to Main Content
AVEVA Product Feedback


Status Declined
Categories System Management
Created by Guest
Created on Aug 19, 2022

Normalized view of the Database Security Table

Currently, the Security column in the Database Security Table uses the following notation for its values (example): piadmin: A(r,w) | piadmins: A(r,w) | PI Readers: A(r) | PIWorld: A(r) This crams multiple PI Identities and access types into a single cell. Consider adding an option to view this table in a more normalized form. That is, split the Security column into PI Identity and Access Type (read or write). This way, we can sort the PI Identify column to group PI Identities together. Then we can easily see which tables a PI Identity has access to rather than visually inspecting for the PI Identity's name in the Security values.
  • ADMIN RESPONSE
    Aug 19, 2022
    Thank you very much for sharing your feedback on the PI Server. After further evaluation, we have decided to decline this item, as we are not planning on implementing it in the near future due to other high priority items across the PI System. Thank you for your feedback, and know that we are listening and reviewing every item that gets submitted!
  • Attach files
  • Guest
    Reply
    |
    Aug 19, 2022
    I cover this in more detail in my blog post: https://pisquare.osisoft.com/s/Blog-Detail/a8r1I000000HZi7QAG/pi-spreadsheets-of-justice