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
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Highlight all the modes that are present under Confidence Level.
What are the available join types in teradata?
If a Node is busy what are the steps you can take to avoid ?
What is the opening step in basic teradata query script?
Which is faster fastload or multiload?
What are tpump utility limitations?
Name the five phases that come under MultiLoad Utility.
Explain the new features of teradata?
What are the 5 phases in a multiload utility?
When tpump is used instead of multiload?
Discuss the advantages of using partitioned primary index in a query?
What do you mean by parsing?
how can we analyze the locks ?
How to view every column and the columns contained in indexes in teradata?