How to create a user in Teradata and oracle

Syntax :Create user <username> from<dbc>
as
password=<password>
spool=200000
temporary=200000
permanent=200000;



Query : CREATE USER sai
   FROM dbc
AS
   PASSWORD = ***
   PERM=2000000
   SPOOL=5000000
   TEMPORARY = 5000000;


In oracle first create user then take permission from dba.

Syntax :create user <username> identified by <password>

Query : create user john identified by black;

Then take permission from dba

Query: grant dba to john;

If you are facing any problem in creating user in scott login, try below userid

username:sqlplus
password:as sysdba

First connect sqlplus user then after create user. 


Drop comment here, if any find any bugs in above query.