Differences between Database and USER:
- A Database or a User can be assigned PERM Space
- If the Database Store is assigned 10 GB of PERM, that means it can hold up to 10 GB of Permanent Tables.
- If the User Nancy is assigned 10 GB of PERM, that means she can hold up to 10 GB of Permanent Tables.
- A Database or a User can be assigned Spool Space
- If the Database Store is assigned 10 GB of Spool, that means all users under Store can each run 10 GB queries.
- If the User Nancy is assigned 10 GB of Spool, that means she can run up to 10 GB queries, and any user created under Nancy will default to 10 GB queries.
- In Teradata, the only difference between a database and a user is that a user can login and run queries.
Roles and Teradata Access rights:
Roles simplify Database administration by assigning access rights to tables and other objects, and then groups of people with similar job functions (or roles) can access these objects.
It is as simple as creating different roles for different job functions and responsibilities, and then granting specific privileges (access rights) on database objects to these roles, then granting a role or roles to users who share the same privileges.
Imagine a thousand users accessing certain databases, tables, views, macros, or stored procedures and having to grant each individual user access rights to these objects. Why not, instead, create a role that provides access to these objects, and then assign everyone needing this access that role.
Roles simplify this very important security assignment. This is the way that Teradata prefers to implement Access Rights.