This session defines what roles and profiles are, why they are important, how they are implemented, and how to use them.

The advantages of using roles, nested roles, and profiles to help administer a Teradata system are described. Examples of access rights issues and how they can be resolved using roles are discussed. The GRANT and REVOKE command formats are shown as well as examples using Teradata Studio. The impact of roles and profiles on users is also explored in this session via examples. This session also provides the newest enhancements (such as Query_Band) associated with roles and profiles in Teradata 15.10. The system views that provide role and profile information are discussed and data is provided based on the examples provided in the session.

Key Points:

  • Learn how to implement roles to reduce the number of rows in the DBC.AccessRights table and simplify user access rights management.
  • Learn how to use profiles in order to change a system attribute (e.g., SPOOL, QUERY_BAND) for many users with a single command.
  • Learn about the system views to display roles, profiles, and users associated with them.

This was a 2005 Teradata Partners Conference session, updated April 2016.

Presenter: Larry Carter, Senior Consultant - Teradata Corporation

This course is offered by the Teradata Education Network. To enroll online, click the Training URL link below to go to the TEN site and Log in. If you're not a member click browse, select your region, and search on the Course Number. Or to enroll by phone, call the Enrollment Center at 1-937-242-4460. Note: You must be a member to register for a course.

Audience: DW Architects, DW Technical Specialists, DBAs, System Admins/Operators

Course number:33452
Training URL:
Format:Recorded webcast
Credit hours:1.00