Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 04 Apr 2012 @ 13:44:32 GMT


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


Subj:   Dbaseid and unknown creator
 
From:   Mark Young

Hi all,

I have a question in regards what happens to a Teradata system if a Dbaseid - the id assigned by Teradata to a identify a database, if it is a user and the user gets dropped. We have numerous tables that show up with a creator unknown, which I am assuming is due to the user being dropped at some stage.

What would happen if this Dbaseid gets reused for another user? Do all the tables with unknown creator pickup the new user and what would that mean as far as access rights are concerned? When a user is dropped, all access rights are also dropped, so one would hope that they would not reappear for the new user!


Mark Young



     
  <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: 27 Dec 2016