Example: Creating an Administrative User - Teradata VantageCloud Lake

Assume that a Teradata system has 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;