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 Posted / 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 |
Post New Answer View All Answers
Name the five phases that come under MultiLoad Utility.
How is the teradata different from oracle?
Steps to create a data model?
How do you determine the number of sessions?
What is meant by a Highest Cost Plan?
How many sessions of MAX is PE capable of handling at a particular time?
Explain the meaning of Amp?
Why does varchar occupy 2 extra bytes?
What is the basic syntax for teradata select statement?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What is inner join and outer join?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
what are the day to day activities of teradata DBA ?
What is a dimension table?
How to Extract data from multiple legacy systems?