microsoft / coe-starter-kit

Other
743 stars 219 forks source link

[CoE Starter Kit - Feature]: View Security Roles applied per App and Tables #6749

Open jimpreston29 opened 1 year ago

jimpreston29 commented 1 year ago

Is your feature request related to a problem? Please describe.

No

Describe the solution you'd like

We may have several apps in same environment and they share the same table. There may be different security roles for 2 Apps that share the same table. Its possible that the app Owner may share the wrong security role to a user which gives them higher access to a table than required.

Describe alternatives you've considered

Currently, to view the security role access for each table, we have to click on each security role from PPAC. This is time consuming.

A colleague has created an App that does this checks. It would be good to have this in CoE or PPAC

Additional context?

No response

Jenefer-Monroe commented 1 year ago

Can you share the technique the colleague used to gather this information?

jimpreston29 commented 1 year ago

Hi I know he presented it to Paul liew a few months ago. Paul could probably give you a better idea of the technique . If you want an actual demo then I can ask him to be available

On Thu, 28 Sep 2023 at 14:56, Jenefer Monroe @.***> wrote:

Can you share the technique the colleague used to gather this information?

— Reply to this email directly, view it on GitHub https://github.com/microsoft/coe-starter-kit/issues/6749#issuecomment-1739265843, or unsubscribe https://github.com/notifications/unsubscribe-auth/ASW3ZHCCH6U7BWL7VSJ52UDX4V6ZRANCNFSM6AAAAAA5LAI7FI . You are receiving this because you authored the thread.Message ID: @.***>