Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 15 Dec 2004 @ 17:41:31 GMT


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


Subj:   Re: DUMP/RESTORE access right granting
 
From:   McBride, Michael

Understood, but what if you wanted to cascade a privilege on "all" database owned by the DBC (top down). Is there any way to do this without executing the same grant for each separate database in one single grant statement? I know you can create multiple grant statements using a query against the dbc.databases table, but that seems like a workaround?


mem



     
  <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