I've been using basic SQL Server tools for a couple of years now and i'm having to administer my first database now.
I have a completely stand-alone machine with 2 user accounts - Admin and User.
I've developed 7 executable applications, 6 of which are available to the User and all 7 of which are available to the Admin.
I'm assuming that when the User runs one of the executables, the executable assumes the same access rights (i.e. at the moment, the application does not find the database). I Think I have set the User account up as a valid SQL Server Logon via the Security
/ Logins / New Login... option from the object explorer, however I'm not sure how to restrict them to only Insert, Select and Connect securables - it seems that all I can update is the securables for the server, not the database its self.
I would search the internet for the answer but I'm not sure of the specific terminology to search for.
Thanks in advance
View Complete Post