Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 10 May 2008 @ 00:01:20 GMT

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

Subj:   Re: Control access to view
From:   McCall, Glenn David

Could you use a macro?

Via permissions you could restrict the certain users to only running the macro. The macro would take a parameter of the account number and would return just that account number's details.

In this model, the macro will need to have permission to access the view. The "restricted" users would have permission to exec the macro and *no permissions* on the view (i.e. they are not allowed to directly query the view - they can only query the view via the macro).

For the other "unrestricted" users who can retrieve multiple records they could have permissions to access both the view and the macro, or just the view as you see fit.

Glenn Mc

  <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