16.10 - Advantages of Using Roles - Teradata Database

Teradata Database SQL Fundamentals

Teradata Database
Release Number
Release Date
June 2017
Content Type
Programming Reference
Publication ID
English (United States)
  • 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, Teradata Database inserts one row per role per privilege in DBC.AccessRights, and one row per role member in DBC.RoleGrants.