O'Reilly logo

Teradata Database Administration – The Fundamentals by Thomas Coffing, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 7 - Profiles

“It's always been, and always will be the same in the world: the horse does the work, and the coachman is tipped.”

-Anonymous

Profiles

It is easy to get mixed up between a Profile and a Role. Think of it as “Profiles are for People” and “Roles are for Rights”.

Profiles define system attributes for users (people). By assigning a profile to a group of users, you can rest assured that all group members will operate under a common set of attributes.

Create a different profile for each user group, based on system attributes that members share.

If you do set the value of a parameter in the profile the settings override the settings for the user in a CREATE USER or MODIFY USER statement.

If you do not set the value of a parameter, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required