Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 14 Mar 2006 @ 19:31:41 GMT


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


Subj:   Re: Reference tables for AccessRights and TableKind
 
From:   Dempsey, Mike

You need to correct the following object type:

change

     ('Q','TRIGGER')

to

     ('Q','QUEUE TABLE')

And the following Access right:

change

     'RO','XXX'

to

     'RO','REPLICATION CONTROL' or 'REPLICATION OVERIDE'

Do the following rights really exist?

     'AN','ANY PRIVILEGE'
     'HR','HUT RELEASE LOCK'
     'S' ,'RETRIEVE/SELECT'    (I thought it was always 'R')
     'WL','WRITE LOCK'

Mike Dempsey
Teradata Client Tools



     
  <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