Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 18 Nov 2010 @ 08:21:48 GMT


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


Subj:   Re: Access only DDLs not data
 
From:   Vinay Bagare

If you are prior V13, you will have to give some permission that does not inadvertently compromise database.

For view database, you could probably give CHECKPOINT permission (Assuming that view database has only Views only).

     GRANT CHECKPOINT ON  TO ROLE_Name/UserName;

If you are running V13 Teradata database GRANT SHOW ON TO ROLE_Name/UserName;


Thanks,

Vinay Bagare



     
  <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