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
- 3686 Views
- I also Faced
- E-Mail Answers
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 |
Syntax for case when statement?
What is the purpose of joins in teradata and what are the available join types?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Explain the term 'database' related to relational database management system?
How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????
hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?
What are the steps involved after the disk manager passes the request?
There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?
Describe the set operators in teradata.
Why FLOAD does not support multiset tables??
How do you create tables? Exact syntax, and create profiles, users in teradata?
Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M
Teradata 
