Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


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

Reddy,

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.


Cheers,

Dave

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



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