Mssql db tabs permision

1

Hello, can i set or disable permision to specific db tabs for user? I need to user not see all tabs in db. Etc. tab customer granted but tab orders can disable. And how can i do it? Thanks

2

Tab means tab or table? Disable as in denied?

3

I mean tables, and I need to deny access to specific tables in four db with same table structure for specific user.

4

Here'd be one way to achieve this

GRANT SELECT ON "dbo"."Customer" TO "User1"
DENY SELECT ON "dbo"."Orders" TO "User1"
5

Ok, how to make this without powershell in SQL Server Management Studio? Thanks

6

Those statements can be run in SSMS