How to configure permissions for a table in MS SQL Server?

Question

PHP

Hello uv. community. Tell me, please, I connect remotely to the MS SQL Server database via PHP, most tables are normally pulled out normally, but some of the same database does not give out, what could be the problem? Can some restrictions be specified specifically for the table, if so, where can I see them?

Answer 1

Difficult to answer the question, too little data.
What happens if you connect to MSSQL through Management Studio? Do you see the table data?
What happens if you connect to it through the adminer?
UPD. Alternatively, you don't have role/permission on some of the tables (there might be another schema).