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
Tab means tab or table? Disable as in denied?
I mean tables, and I need to deny access to specific tables in four db with same table structure for specific user.
Here'd be one way to achieve this
GRANT SELECT ON "dbo"."Customer" TO "User1" DENY SELECT ON "dbo"."Orders" TO "User1"
Ok, how to make this without powershell in SQL Server Management Studio? Thanks
Those statements can be run in SSMS