Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 17 Jul 2003 @ 19:59:56 GMT


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


Subj:   Re: GRANT at database level..
 
From:   Christie, Jon

The INDEX right cannot be granted at the database level. Only at the object level. So I guess you'll have to grant DROP TABLE at the database level to the user who's going to be collecting stats. You can collect stats if you have the DROP TABLE right.

If you really, really need to grant INDEX instead, you can write a query that will generate all the GRANT INDEX... statements. Then .export report the query and .run the resulting file. It's a useful technique.



     
  <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