Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 21 Apr 2009 @ 14:12:44 GMT


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


Subj:   Re: An owner referenced by user does not have index with grant option
 
From:   Geoffrey Rommel

  It seems we cannot grant index right at database level. Any ideas how can we get this resolved?  


Consult the manual. You must either grant INDEX on the individual tables, which is a maintenance headache, or grant DROP TABLE on the database, which could be risky for some grantees.

I submitted an ER some time ago asking for INDEX at the database level (as probably many others have), but for now those are your options.



     
  <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