Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 22 Mar 2002 @ 16:58:34 GMT


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


Subj:   Mysterious column in AccessRights
 
From:   Geoffrey Rommel

Table DBC.AccessRights contains a column called CreateUID, which is different from the GrantorID and sometimes null. I am unable to divine what this column might be. I have thought of these hypotheses, all of which I have ruled out by querying the data dictionary:

- It's the creator of the User.

- It's the creator of the TVM.

- It's the creator of the Database.

We are on V2R.04.01.00.10. In previous releases, the Data Dictionary Reference said nothing about this column; now, for column DBC.AllRights.CreatorName, it says, "Returns the name of the user who created the database, table, or the name of the user's creator." This doesn't seem to be correct.

In short, I am stumped. Any ideas?

--wgr=



     
  <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