" command after the login statement in Fastload script. Without that user cannot create the error/UV table. How to avoid setting role in this case?" />
 
Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 21 Dec 2005 @ 09:48:38 GMT


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


Subj:   SET Role in Fastload
 
From:   Agarwal, Rishi

Hi,

We are using ROLE level access permission. Every time when the user logs in, he has to set the role in the current session to activate the access rights.

Do we need to set the Role every time for each session? We can do the same in case of BTEQ script. But how to handle that in Fastload/Multiload scripts.

We are getting error while executing the "SET Role <rolename>" command after the login statement in Fastload script. Without that user cannot create the error/UV table. How to avoid setting role in this case?


Thanks

Rishi



     
  <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