Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 4086 Views
- I also Faced
- E-Mail Answers
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
What is meant by a Channel Driver?
Differentiate primary key and partition key?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What is the syntax for case when statement?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
How to Extract data from multiple legacy systems?
What is multi insert?
What do you mean by teradata intelliflex?
What is the purpose of indexes?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What happens in a conflict? How do you handle that?
How you will check the version of teradata?
Explain PDE.
what is object level locking ? where do appear this type of locking ?
What is the use of having index on table?
