Set permission for user at particular database

[Guvera]

Hi friends,

I am using asp.net 2.0 application & ms server 2005. Using sp_addlogin,sp_adduser and sp_password I create a login and set username and password for particular database.While i connect my sql server i give login(not default login sa) name example itect and give password ****. I set permission to user for particular database. While i login i didnt access all the db.I can accessed only that what permission i gave for db.Its working fine. What my question is while i login at a particular login name and password i need to show in my ms server 2005 as a particular db only. suppose i give permission user 'Guvera' to db 'dbmap' means can i show only dbmap??? Unfortunately in my ms server i see all db but i cant access. Shall i show only my access db ?? Is it possible??

Please clear my doubts. If any mistake in my doubts, plear tell what is it??

[si_the_geek]

Each user can be given permissions to multiple databases, but they can only be given one default database (it is the one they will 'see' when the log in).