What are the advantages of “roles”?
• Simplify access rights management by allowing grants and revokes of multiple rights with one request.
–>useful when an employee changes job function (role) within the company.
–> If a job function needs a new access right, grant it to the role and it is effective immediately.
• The number of access rights in the DBC.AccessRights table is reduced.
–> Disk space usage is reduced when rights are managed on role level rather than individual level.
•Improves performance and reduces dictionary contention for DDL, especially CREATE USER.
–Removal of hierarchical inherited rights improves DDL performance and reduces dictionary contention.
0 comments:
Post a Comment