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 / 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 |
What are two examples of an OLTP environment?
Why AMP & PE are called Vprocs?
I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata
How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale
What is TPD?
What is the difference between teradata and oracle?
What is real time and near real time data warehousing?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Does SDLC changes when you use Teradata instead of Oracle?
Diff b/w v2r5 and v2r6 ?
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
Explain the new features of teradata?