Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
little83
Starting Member
3 Posts |
 Posted - 2009-03-11 : 09:11:44
|
| Dear allI use sql as database server for my c# application and what I trying to do at the moment to all different users to register to the sql server and each one may has his password and username, how can I do thathow can browse the available database for each user..or the username and password for each user allow him to access all databse available on the server? |
|
|
dengar
Starting Member
4 Posts |
Posted - 2009-03-11 : 10:38:02
|
| It's very simple:1. Open MS SQL Server Management Studio2. In the Object Explorer connect to your Server3. Under the folder Security you will find LoginsAnd you can easily administer users, logins and rights there...Feel free to let me know if you have any other questions |
 |
|
|
little83
Starting Member
3 Posts |
Posted - 2009-03-11 : 14:44:01
|
| But I want to display the database available for each user when he login with his user name and password |
|
|
|
|
|
|
server