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

Similar questions

C

CryptoPython2018-10-23 22:19:39

How to get data from the database from the table, if 1 (column with primary key) and the same column are referenced by 2 other columns (2 foreign keys and 1 primary? 1Reply

M

mrss2016-05-26 01:35:31

Is it possible to get the modified string? 1Reply

L

lizanin2016-05-31 10:55:50

SQL. A different syntax for getting the result? 2Reply

A

Alexey Smirnov2018-10-31 20:58:38

How to synchronize SQL database between two computers? 1Reply

V

Vitaly Rybchenko2016-06-20 10:20:35

How to execute trigger once after update is there update in it too? 1Reply

Didn't find what you were looking for?

Ask your question