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;