Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Tue, 27 Nov 2012 @ 15:43:07 GMT


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


Subj:   Re: Restriction on Space Movement
 
From:   Anomy Anom

< -- Anonymously Posted: Tuesday, November 27, 2012 10:15 -- >

Don't grant CREATE/DROP DATABASE directly to this group of users. Create a Stored Procedure, using a privileged ID, which uses dynamic SQL to do the CREATE DB, GIVE, DROP DB that accomplishes the "move space" operation, accepting the target DB and size as parameters. Then grant the users permission to execute the SP.



     
  <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