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 |
Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
which option is used to restart the fast load script?
Highlight all the modes that are present under Confidence Level.
What are some primary characteristics of teradata?
What is the process to restart the multiload if it fails?
Difference between client character set and server character set? What is the use of these two?default character set in teradata?
if collect stats but it show low confidence why?
What is the purpose of using case expression in teradata?
What is called partitioned primary index (ppi)?
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
Define views in teradata with general syntax.
what are the day to day activities of teradata DBA ?