how can i restrict an user to access a particular database in sql server 2008 express?

Question

im using sql server management studio 2008. I use windows authentication to login.
I want to restrict a computer user from accessing a particular db in the local server.
is it possible?

Answer 1

When you create a windows/domain login on SQL server, it does not by default have access to anything, you need to explicitly grant it. So what you need to do is to create a login and then grant it access (of whatever level, such as readonly, read/write, db_owner etc) to whatever db you need it to have access to. It will not be able to access anything outside of what you granted.

Answer 2

Hello;



First you need to create one windows login under active directory, and then try to log in to the operating system with new user name and password.



Second; log in back to the OS with the admin id, and then open the SSME, login as SA and then under Security/Login under Object explorer, right-click on the login and then select "New Login"



The window appears where it will ask you the main details, selecte window authentication and then click the search box and then in there search for the user you created in the step 1 and click OK.



and in the same window, click on the "user mapping" - here it will asks you which all the database this new user needs, you can check those database only and for the database not selected when the user logs in he will not be able to access them.



Once this is done, just log in as that user and then log in to the SSME with the same ID and password and see if the list of databases are as needed.



Hope this helps;

Answer 3

Sometimes I consider most guys are sociopaths via feminine standards. Or, in evaluation, reasonably autistic (no offense to humans suffering from autism). Like the guy who said: "I typically are attempting not to get to emotional about things, its best a buzz kill in my intellect." chum used to be just being honest. Empathy is extra learned than we think. Ever visible a infant pull an animal's tail? Or giggle when she pushes one more child around, when you consider that she`s made some style of have an effect on and got a response? I feel a number of guys certainly not develop out of that. It is tougher to achieve in most cases male ambitions if you are empathetic. They get punished for it. Purpose they socialise themselves, with their %-mind.

Answer 4

No, this is not possible on Windows 7.

On Windows 8, yes. Although, I suggest you to search some more info on google.