TeraTeam UK Teradata DBA Definition
Role:
A Role within Teradata is a database object that allows user access rights/permissions over other database objects to be grouped. Ordinarily database Users are individually granted access rights to database objects, however, should a group of users require the same access rights over the same database objects, then these Users may be assigned a Role, and the Role is instead assigned the access rights. Advantages of this approach include:
- Ease of Administration - Access rights only need to be granted once to the Role with the role then being assigned or revoked to individual Users as required.
- A reduction in the data held in the data dictionary Access Rights tables, potentially reducing logon and query run times.
- Increased flexibility in Access Rights maintenance through additional higher level of granularity.
It is important that well researched policies and standards are in place prior to Role implementation, a task that TeraTeam UK are highly experienced in performing.
