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:
grant,role=dba,operation=any,object=DBID.CURRENT
grant,role=auditor,operation=read,object=DBID.CURRENT
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:
grant role=auditor,operation=read,object=1000-1200
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 |
Brainstorm ID | 8983 |