Table restriction - MSSQL connection

Jas
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
AlexT
Dataiker

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.

https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-transact-sql?view=sql-server-ver15 

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