Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi - Please can you let me know, how I can restrict the MSSQL connection to a table in the connection setup level?
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.