Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4319


Highlight all the modes that are present under Confidence Level.

915


What are the available join types in teradata?

1010


If a Node is busy what are the steps you can take to avoid ?

2344


What is the opening step in basic teradata query script?

974


Which is faster fastload or multiload?

1036


What are tpump utility limitations?

1055


Name the five phases that come under MultiLoad Utility.

926


Explain the new features of teradata?

990


What are the 5 phases in a multiload utility?

981


When tpump is used instead of multiload?

1037


Discuss the advantages of using partitioned primary index in a query?

903


What do you mean by parsing?

1055


how can we analyze the locks ?

2058


How to view every column and the columns contained in indexes in teradata?

979