New answers tagged


You might be asking too broad of a question but if you wanted to have a user only have access to a table in SQL Server you could simply do a: --Create Server Level User USE [master] GO CREATE LOGIN [(UserName)] WITH PASSWORD=N'PutPasswordHere' DEFAULT_DATABASE=[DatabaseName] GO --Create DB Level Uesr use [DatabaseName] GO CREATE USER (username) FOR LOGIN (...

Top 50 recent answers are included