Archives of the TeradataForum

Message Posted: Thu, 06 Sep 2012 @ 19:29:18 GMT

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

You can do this through Row level security. You can create one view where it takes the UserID of the session and gets the appropriate Source System ID to result the rows which are authorized.

Like:

     select ,
        from .
        where sourceSystemID in (select sourcesystemID
                                    from .
                                    where username = [user]
                                )

In the above user is Teradata Element which gets you the UserID of the session, RowlevelTable is Support Table which Contains UserID and their corresponding SourceSystemID.

Hope it helps you.

Regards,

Hanumath Padarthi
Teradata System Administrator

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