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?



  <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