Archives of the TeradataForum
Message Posted: Thu, 06 Sep 2012 @ 18:09:31 GMT
< -- Anonymously Posted: Thursday, September 06, 2012 10:36 -- >
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|