It would be helpful to be able to provide permissions for all files in a database (update for dba roles, read for auditors, for example) rather than having to enumerate every permission for every file for each applicable role - something like:
This would remove the need to provide a similar grant for every one of the hundreds of files in the database. A file number range might be an alternative:
for access to files "1000" thru "1200".
This would make the permissions easier to manage and review, clarifying who has access to what.
|Use Case||RBAC: Operational Efficiency, improved security, all phases|
|Created on Brainstorm||03.30.2021 07:21 pm|