Getting Started with Teradata ... first time. 2

[jorgevasconcelos]

Hi, guys

Since Teradata is the first database besides Oracle that I work with (and today was my first constact with the database itself), I have some (simple) questions.
Here it goes :
1) First of all, how do I connect to the database?(Is there any native navigating tool such as "sqlplus" that I can use ?)
2) Is there any default user and password such as Oracle´s "SYSTEM/MANAGER" that I can use for the first connection ? (If yes, could you please tell me them ?)

That´s pretty much for now.
Thanks in advance.
Jorge

 

[tdatgod]

Hi,
Teradata has Client software that can run on practically every platform,

MPRAS (NCR's Proprietary UNIX)
WINDOWS ( NT and 2000 ) ( it might run on 98/ME but not officially supported.
Solaris ( INTEL and Sparc )
HPUX

I don't think we support LINUX yet. I will have to check.

These client application can communicate with any Teradata server which runs either on

MPRAS (NCR's Proprietary UNIX)
WINDOWS ( NT and 2000 )

Knowing which versions of client platform and which version of server platform would allow me to tailor this response to your particular system.

However here are some basic starting points.



1. BTEQ (available for all platforms),
BTEQWIN, QUERYMAN, WINDDI (only on Windows)

2. user DBC ( case insensitive )
password DBC ( case insensitive )

Even though DBC is our administrative user, DBC is subject to the same rights and privledges as any other user. if you create a table BLORT and

revoke all on BLORT from dbc;

DBC will not be able to access table BLORT;

Also DBC is not allowed to create any tables in his own Database (DBC) since this is reserved for system tables only.

Therefore the first thing you should consider is creating another database from DBC like....

Create database mydbc as perm = 10e6;

or

create user mydbc as perm=10e6, password = blort;


(10e6 == 10,000,000)

On teradata the only difference between a database and a user is a user has a password and therefore can logon.




If you are using the DEMO vesion of Teradata for Windows there is a START MENU group called

Teradata Client

and that is where all of our utilities are. By default they are set up to find the teradata on the local machine.


If you are a paying customer, then you need to get these utilities from your Teradata DBA or NCR support staff.



Typically from BTEQ you use

.logon <machine>/dbc

it will then prompt for password
password:

and you type in dbc

In a one teradata system network the default <machine> name is dbccop1

if you look in the hosts file ( or you have to make these entries manually to your yellow pages map on UNIX ) you will see something like

127.0.0.1 localhost demo1099cop1 dbccop1

COP1 is the designation our CLI ( Call level Interface ) uses you recognize this is a Teradata Server. therefore in this case yoyu could say

.logon demo1099/dbc

or
.logon dbc/dbc

and it would access the same teradata server on the local machine.


QUERYMAN and WINDDI use the ODBC interface and therefore the Association of the Connect Name to the Machine Name are set up through the ODBC Administartion utility and not in the HOSTS file.

Hope this helps.

 

[BillDHS]

tdatgod: I can't believe you gave this guy the admin logon and password through a bboard. You don't know who he is. If he is the authorized administrator for the system he should have no problem getting it through business channels.

 

[TeraOz]

At first I was inclined to agree with BillDHS re disclosing admin user and default password - i.e. not a good idea, however after a few seconds came to the conclusion that whoever administers a system and leaves the default password for DBC (or any other DBMS/OS default user) deserves what they will surely get.

For that matter, anybody who relies on their user (or hacker) community's lack of basic system knowledge for securing their systems also deserves what they will get. Heck, you can always download the whole Teradata documentation set right from the internet - it's all there for you! (see the installation guides)

I have come across quite a few systems with default account/passwords (and I always check too) - it amazes me that people don't change these the first time they log on...

I guess some people never learn!

Regards, TeraOz

 

[tdatgod]

Hi,
We just gave out 500 copies of the Teradata v2r4.1 Demo CD at the partner conference this past week with

a complete version of Teradata v2r4.1 GCA
a complete set of TUF 6.1 utilities
A complete set of Documentation for TW 6.1
some CLI, ODBC and JDBC demo applications.
the complete source code for the DEMO APPS.

These people who got this copy of the DEMO Disk or who have downloaded it from

http://www.teradata.com/dwdemo

have no recourse except Public forum.

The default Passwords are embeded in the sample apps and since the code for those APPS is on the DEMO CD anyone could look through the code and find them.


Also I looked through the documentation available at

http://www.info.ncr.com

and found 2 places which have the password. out of 75 documents and 10,000 pages finding only 2 places is quite extrodinary.

I guess I will point out this over sight to my manager and see if we can get the Password changed for the DEMO CD.


Also I will let the information engineering staff know about the 2 locations I found in the documentation.

Thanks for trying to keep me honest.

--