Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 11 Sep 2003 @ 07:57:39 GMT


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


Subj:   Re: Purpose of user 'All'
 
From:   Dieter Noeth

Karen Gebhard wrote:

  What is the purpose of the user named 'All'? What would happen if I dropped this user?  



ALL, DEFAULT and PUBLIC are no real users, they don't have a password. And you don't have to worry about dropping it, because even dbc doesn't have any rights on it. And dbc can't grant any rights, although dbc is an owner, because there's no entry in dbc.children ;- )

IMHO it's a placeholder to prevent the creation of a real database/user with that name (it's the same with users ), because this would confuse the parser, e.g.

GRANT ... TO ALL dbname
GRANT ... TO PUBLIC
GRANT LOGON AS DEAFULT ...


Dieter



     
  <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: 15 Jun 2023