CREATE USER Examples | Teradata Vantage - 17.10 - Example: Creating an Administrative User - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

Assume that a Teradata system has just been installed. The DBA has logged on as user DBC and has submitted a CREATE USER request to create the administrative user called SYSADMIN. As user SYSADMIN, the DBA submits CREATE DATABASE requests to create such required databases as finance, executive, engineering, manufacturing, and marketing.

Still logged on as user SYSADMIN , the DBA then adds a new user to the finance database using a CREATE USER request, as follows:

     CREATE USER marks
     FROM finance AS
     PERMANENT = 1000000,
     PASSWORD = finan1,
     SPOOL = 1200000,
     FALLBACK PROTECTION,
     DUAL AFTER JOURNAL,
     DEFAULT JOURNAL TABLE = finance.journals,
     DEFAULT DATABASE = finance,
     STARTUP = 'EXEC setpf;'
     ACCOUNT = '$mfinance','$hfinance';

After user marks is created, the DBA submits the following request to grant finance privileges WITH GRANT OPTION to marks .

     GRANT ALL ON finance 
     TO marks 
     WITH GRANT OPTION;