Set permission for user at particular database
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??
Re: Set permission for user at particular database
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).