Restrict Data base on User's name and group

[Wee Loon Goh]

Hi,

I have a spotfire dashboard which connect through data (MS SQL Server) instead of using any information link. The dashboard have multiple data table connection with MS SQL Server. But I would like to restrict the data appearance base on user's username login and his group. I have a data table connection which call Owner and inside having username login and group column information. The rest of data table having also group column in it. Can I create a join to link the rest of data table to Owner. And restrict the data to be shown base on their name and group

 

Thanks in advance

[Varma Nadimpalli]

Helloshinngoh,

 

Try using "Use parameters for personalized queries (users and groups)" feature in custom query option.

https://docs.tibco.com/pub/sfire-analyst/10.6.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/connect/connect_details_on_custom_query.htm

[Priyank Dwivedi]

The link does not work. Can't open it.