Why does the user not see the MS SQL tables?

M

Mikhail2020-09-14 19:18:23

SQL Server

Mikhail, 2020-09-14 19:18:23

How to give read-only permissions to a user?
Now there is a user, if you go to the server under him, then no tables are visible, but under the admin everything is ok.
It is necessary that the tables and read-only rights be visible

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

K

Konstantin Tsvetkov, 2020-09-15
@tsklab

GRANT instruction .

L

Lazarev-MK, 2020-09-24
@Lazarev-MK

Role at the database level - db_datareader