SQL Server User Mapping - Limit view of databases for a user

Question

So I'm using this jQuery plugin:

http://p.ar2oor.pl/cprogress/

I won't post any code cause there is just way to much. Basically, if you go to the site you will see how quickly their progress bar loads. I have set mine up working in the exact same fashion, but just with different images. It delays for half a second and then appears. Why is it doing it, and what can I do to prevent this?

Solution

To do that you would need to remove the guest account for all the other databases. While the user can see the other databases, he can't open them and do anything (unless the guest account or the public role within those databases have access to anything).

Comments

[Sneaksta]

Yeah sorry I've been looking and looking but I don't understand the code well enough to be able to find the problem. I'll give jsfiddle a go.

[Jaime]

Thanks for the reply mrdenny. The requirement is that for the user to see only the database he is assigned to. I already have a similar user that is doing just that but I cannot replicate the functionality. The person in charge is away on vacation and I have never tried to do this before. It's possible that there are a couple of more steps that I need to do like prevent the user to view the other databases.

[Jaime]

Hi Nick, Thanks for the reply. I was able to deny view of any of the database to the user but for the life of me I can't find an example as to how to grant a user to view the specific database. If I had a user TheUser and the database is MyDatabase, what would be the syntax in granting him view? Thanks a lot!

[Mikko Ohtamaa]

Unless you can isolate (or bother) the problem it is very difficult for people to help you. Try jsfiddle.net.

[userSteve]

Nope that doesn't work :(