Table restriction - MSSQL connection

Level 2
Table restriction - MSSQL connection

Hi - Please can you let me know, how I can restrict the MSSQL connection to a table in the connection setup level? 

0 Kudos
1 Reply

Hi Jas,

It's not possible to restrict an MSSQL connection at the table level in DSS,  only at the database level.

However, you should be able in MSSQL, by granting the user in the connection with specific table-level access. 

If you do take this approach you will need to ensure you use wildcards for tables names to grant user permissions on any tables with the suffix/prefix defined in the connection. 


0 Kudos