Archives of the TeradataForum
Message Posted: Fri, 10 May 2008 @ 00:01:20 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|