Create a new user in SQL Server
How to give to the user a premission
How to give permission by code
--Anname õigus kasutajale Nikita1 vaadata tabeli autod sisu
GRANT SELECT ON autod TO Nikita1
GRANT UPDATE ON autod TO Nikita1
--keelatal
DENY DELETE ON autod TO Nikita1