Archives of the TeradataForum

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

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

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>>