- Simplify privilege administration.
A database administrator can grant privileges on database objects to a role and have the privileges automatically applied to all users assigned to that role.
When a user’s function within an organization changes, changing the user’s role is far easier than deleting old privileges and granting new privileges to go along with the new function.
- Reduce Data Dictionary disk space.
Maintaining privileges on a role level rather than on an individual level makes the size of the DBC.AccessRights table much smaller. Instead of inserting one row per user per privilege on a database object, Vantage inserts one row per role per privilege in DBC.AccessRights, and one row per role member in DBC.RoleGrants.