Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 06 Nov 2002 @ 10:21:16 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: What is the doff b/w Database name and User name in Teradata?
From:   David Wellman


As has been pointed out a user has a password and can therefore login/logon to the DBMS and issue SQL requests. A database does not have a password and therefore cannot logon and issue sql requests.

Just to make it clear, this is the ONLY difference between a user and adatabase.

They can both have space limits, they can both have tables, views, macros etc etc owned by them, you can grant and revoke accessrights to both of them.



Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023