Archives of the TeradataForum

Message Posted: Thu, 06 Sep 2012 @ 19:30:07 GMT

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

We have created several views that check user against a table to see if they have access. This would mean at least one more join in the view, but it works well for what we're using it for (named value pairs). So in the source record, we differentiate the type of data, and then in a set of tables, we differentiate based on the user's available roles (so that we don't have to do anything fancy with our users for the other, normal views).

iv

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