how to grant/deny permissions in sql server and to map the users to UserID in database User table?

Question

I need to grant permissions to a user and then to connect user with userID in a table. I have UserID Column with an ID (125845) for an example, and windows logon is SSchmidt. I want to grant and deny some permissions for this user and to connect the user with his ID. I´ve tried this but i get an error (wrong syntax where "\"):

GRANT SELECT, INSERT, UPDATE ON tbl_Auto TO DADDO_PC\SSchmidt

Obviously the '\' in that username is causing an error. Try wrapping it in brackets. — Dan, Jun 30 '14 at 19:52
thanks, i have tried single quotes and wrapping it in brackets but it didnt work, now i´ve tried double quotes and it works. — user3613744, Jun 30 '14 at 19:59

score 0 · Accepted Answer · answered Jun 30 '14 at 19:58

0

This should do it:

GRANT SELECT, INSERT, UPDATE ON TABLE tbl_Auto TO [DADDO_PC\SSchmidt]

answered Jun 30 '14 at 19:58

Kris Gruttemeyer

872
7
19

thanks this works too, but how do i connect the user (SSchmidt) with a UserID in my database table? – user3613744 Jun 30 '14 at 20:04
Great article here on that: http://stackoverflow.com/questions/20907859/grant-syntax-for-domain-user – Kris Gruttemeyer Jun 30 '14 at 20:06
Thanks, but there´s nothing about mapping a windows user to sql database ID column – user3613744 Jun 30 '14 at 20:25
Have you tried looking in the GUI under Security->Logins and finding the user that you created and mapping it that way? – Kris Gruttemeyer Jun 30 '14 at 20:40
I´ve tried looking in the security logins but i didn´t see any option to map the user to a value in a column – user3613744 Jun 30 '14 at 20:48

how to grant/deny permissions in sql server and to map the users to UserID in database User table?

1 Answers1