i added a new user to my sql 2014 database using the gui and now when i try to do grant insert on dbo.mydatabasename to thenewusernameIadded it says Msg 15151, Level 16, State 1, Line 1 Cannot find the user 'theusernameIadded', because it does not exist or you do not have permission. how can I grant limited access to this newly added user
You need to create a database login and map your SQL Server Instance login to the database one. This Knowledge Base article shows you how.
