16.20 - CREATE PROFILE - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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, profiles 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