15.10 - CREATE PROFILE - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Purpose

Creates a profile that defines a set of parameters. You can then assign the profile to multiple users.

Because profiles exist in system space rather than in user or database space, they are not part of the database ownership hierarchy.

The value for a profile attribute supersedes any corresponding values specified in global defaults or in the user definitions of profile member users.

Required Privileges

To use CREATE PROFILE, you must have the CREATE PROFILE privilege.

To assign a row-level security constraint to a profile, you must have the CONSTRAINT ASSIGNMENT privilege.

New users do not implicitly have the CREATE PROFILE privilege. User DBC or a user who has the CREATE PROFILE privilege WITH GRANT OPTION can grant this privilege to another user.

None.

Syntax