Hi friends
This is suneel and i am new to teradata.
In both situvations teradata administrator and teradata sql
assitant 12.0
1)How to create database in teradata and under database
how to create user.
2)How to create table under that user and giving privilizes
to that user.
Thanks alot.
Answer / chinna
Hi suneel first of all you create the user automatically
create database.first you login tdadmin after that
create user username(suneel) from dbc as
permanent=2000000,
spool=2000000,
temporary=2000000,
password=suneel;
Is This Answer Correct ? | 2 Yes | 0 No |
In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??
What is the command in bteq to check for session settings ?
Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M
Where is teradata rdbms used?
What is upsert statement in teradata?
What is the process to restart the multiload if it fails?
What is a level of granularity of a fact table?
If RDBMS is halted what will you do ?
Why MLOAD needs Work Tables?
What is logical data model?
What is the purpose of indexes?
What is dimensional modeling?