Create Profile in Teradata - Syntax and example script - assign predefined system parameters to new users

A profile is a set of system parameters that can be assigned to a group of users.

The following request creates a profile called finance_report that defines the default database to be personnel:

    CREATE PROFILE finance_report AS

      DEFAULT DATABASE = financial;

The following request assigns the finance_report profile to a new user:

---- create and empty role

create role report_user;

create user training_2

from "financial"

as

password = "training_2"

perm = 40000

default role = "report_user"

profile = finance_report

;

Next we can validate that any query from this user looks in the 'FINANCIAL' database by default.

Profile assigned defaults every search to the default database