Closed ParthaI closed 2 years ago
@ParthaI I would suggest having a turbot_grant table to capture grantee with status (Active/Inactive) and associated grants (Permissions)
turbot_grant
Example query results
Results
``` > select id, identity_status, ientity_family_name,level_trunk_title from turbot_active_grant +-----------------+-----------------+---------------------+-------------------------------------------------------+ | id | identity_status | ientity_family_name | level_trunk_title | +-----------------+-----------------+---------------------+-------------------------------------------------------+ | 161525342357056 | Active | Smyth | User > Metadata > ReadOnly > Operator > Admin > Owner | | 229155810239578 | Active | Behera | SuperUser | | 228825782849182 | Active | Chakraborty | SuperUser | | 216704470305117 | Active | Das | User > Metadata > ReadOnly > Operator > Admin | | 232513631394343 | Active | Behera | User > Metadata > ReadOnly > Operator | | 240323569425816 | Active | Behera | User > Metadata > ReadOnly > Operator > Admin > Owner | | 165127150940754 | Active | Kumbha | User > Metadata > ReadOnly > Operator > Admin > Owner | | 228825782907553 | Active | Chakraborty | User > Metadata > ReadOnly | | 232514598645748 | Active | Bhardwaj | Role | | 240323894253012 | Active | Misra | SuperUser | | 162687942600473 | Active | Hadianto | User > Metadata > ReadOnly > Operator > Admin > Owner | | 188609043625517 | Active | Wallace | User > Metadata > ReadOnly > Operator > Admin > Owner | | 189875991944587 | Active | Bhardwaj | SuperUser | | 162654220386929 | Active | Bruno | User > Metadata > ReadOnly > Operator > Admin > Owner | | 187951536899783 | Active | Mohanty | User > Metadata > ReadOnly > Operator > Admin > Owner | | 189793356024239 | Active | Bhardwaj | User > Metadata > ReadOnly > Operator > Admin > Owner | | 165127150928460 | Active | Basu | User > Metadata > ReadOnly > Operator > Admin > Owner | | 162199372503739 | Active | Burgess | User > Metadata > ReadOnly > Operator > Admin > Owner | | 240323832580553 | Active | Misra | User > Metadata > ReadOnly > Operator > Admin > Owner | | 162654220385904 | Active | Bruno | User > Metadata > ReadOnly > Operator > Admin | | 232513631215140 | Active | Behera | User > Metadata > ReadOnly > Operator | | 161241086036962 | Active | Admin | User > Metadata > ReadOnly > Operator > Admin > Owner | | 187955963611958 | Active | Mohanty | SuperUser | | 241556185269454 | Inactive | Nayak | User > Metadata | | 212996033743000 | Active | Khuntia | User > Metadata > ReadOnly > Operator > Admin | +-----------------+-----------------+---------------------+-------------------------------------------------------+ ```