I went to Databases > Login
Right clicked on the logins and saw this dialog box. See image.
I have a user new – he just needs to run queries within the SQL server. But should I do in this dialog box?
General, server roles, user mapping, securables etc. – what should I do for this new user - so that he can’t create or change the DBs but just be able to run only update , deletion insertion queries?
Thank you perms.png
Microsoft SQL ServerMicrosoft SQL Server 2008Microsoft Office