Archives of the TeradataForum

Message Posted: Thu, 06 Sep 2012 @ 18:09:31 GMT

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

< -- Anonymously Posted: Thursday, September 06, 2012 10:36 -- >

Hi,

We are receiving data from 30 different source system's and the data is stored in a single table. The users from each source system should only have access to their own data. We can achieve this by creating 30 views and having a filter condition.

Is there any other way of achieving this without having to create 30 different views? Can this be achieved by? creating only one view? If so how?

Any suggestions are welcome.

Thanks in advance.

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