16.20 - Advantages of Using Roles - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Fundamentals

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
zce1519094756513.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
  • 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.