Archives of the TeradataForum
Message Posted: Mon, 13 Jan 2003 @ 21:52:29 GMT
I have a metadata table that I want to limit who has access based on their userid. The following code is embedded in a macro (it could be a view) and only returns rows where the metadata status of the row exceeds the minimum value that the user is allowed to see. (Business users can only see high value metadata while systems users might want to see all of it). The users with 'special' privileges are kept in a table named Metadata_Users. Rather than maintain ALL user ids, our web application defaults to logging on with a generic userid (Metadata_guest). If the user id is not found, the sub-query returns the value associated with the generic id.... Actually it returns the min value which works for me but you would want to validate it works for what you want to accomplish.
AND Metadata_Status_In >=
I hope this helps.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|