Hi suneel first of all you create the user automatically create database.

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.

Question Posted / chinna

1 Answers
4234 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

Please Help Members By Posting Answers For Below Questions

Explain the term 'primary key' related to relational database management system?

1091

Can we collect statistics on multiple columns?

1129

How to select first n records in teradata?

1162

What is a sparse index?

1121

What is inner join and outer join?

1180

Can you connect multiload from ab initio?

1284

What is a level of granularity of a fact table?

1219

What are the multiload utility limitations?

1115

Define views in teradata with syntax.

1129

What are teradata utilities?

1158

What are the various indexes in teradata?

1100

Explain and compare pros and cons of snow flake schemas?

1089

What is dimensional modeling?

1141

What is the meaning of Caching in Teradata?

1185

What is the maximum number of dml can be coded in a multiload script?

1157