F
F
FlyServer2021-10-15 08:55:24
Access rights
FlyServer, 2021-10-15 08:55:24

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

1 answer(s)
M
Mikhail E, 2021-10-15
@FlyServer

In short, yes - you can, this topic is called "Ownership Chains"
(Separation of access and inheritance of permissions)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question