Answer the question
In order to leave comments, you need to log in
How to configure table access in MS SQL Server?
Is it possible to forbid direct access to a table in MS SQL Server, while ensuring the issuance of data from it through a stored procedure? MS SQL Server 2019. Users connect to the database through SQL authentication. There is a table that should be accessible only to the administrator. Other users should receive only some values from it, while they cannot look at it in its entirety (perform SELECT *, for example). Users should only get limited information from a table through a stored procedure, e.g.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question