16.10 - Advantages of Using Roles - Teradata Database

Teradata Database SQL Fundamentals

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
klx1480972732157.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.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.