Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 22 Mar 2002 @ 18:26:59 GMT

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

Subj:   Re: Mysterious column in AccessRights
From:   John Hall

My own experience is that it contains the Creator ID (the DATABASEID for the Creator):

sel d1.databasename (named DBName)
  , t.tvmname       (named TBLName)
  , d2.databasename (named CreatorName)

  from dbc.dbase   d1
     , dbc.dbase   d2
     , dbc.tvm     t

  where t.createuid = d2.databaseid
    and t.databaseid = d1.databaseid

order by 1,2;

From my notes, it looks like the column was added about V2R3, although I'm not sure that it was populated with the earliest releases of V2R3.

If the database, user, table (et al) was created before the column was supported, it contains a NULL.

Since my experience is by experimentation, does it fit your findings?

  <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