Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 09 May 2008 @ 11:38:21 GMT


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


Subj:   Re: Control access to view
 
From:   Diane Wilson

Not in a view, but you could possible do it via a stored procedures / bteq scripts.

Have the userid and password as parameters, check that against a databasetable holding the 'correct' password.

If correct password has been used, run a grant select statement for that userid.

Have a housekeeping process to run daily, hourly revoking granted access.

Can you run grant statements in a procedure - if not call a series of bteqs scripts?


Regards

Di



     
  <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: 27 Dec 2016