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

Enter a subject

Kenneth Barber

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

0 reply Hide replies

Please enter your email address

RELATED IDEAS

Normalized view of the Database Security Table