Table restriction - MSSQL connection
Jaspal
Registered Posts: 9 ✭✭✭✭
Hi - Please can you let me know, how I can restrict the MSSQL connection to a table in the connection setup level?
Answers
-
Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,212 DataikerHi 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.